#1
|
|||
|
|||
Formula help
Hi All,
Does anyone know the formula that will copy the start date into the text 1 column if any rows in the flag 1 column are set to yes? Any help would be appreciated Thanks Planner18 |
#2
|
|||
|
|||
try
IIf([Flag1]=True,[Project Start],"") this assumes that by start date, you mean the project start date. If flag 1 is set to no, (false) I have set the formula to insert a blank, this avoids showing an error message. If you want something different, it can go between the 2 quotes (""). If you want to show the start date of the task, it would be IIf([Flag1]=True,[Start]," ") hope that helps. |
#3
|
|||
|
|||
Perfect! Many thanks.
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Possible to use an existing vlookup formula to also insert correct info and trigger a SUM formula | innkeeper9 | Excel | 2 | 09-13-2016 08:59 PM |
Need help with dragging a formula and changing a reference column as I drag the formula. | LupeB | Excel | 1 | 10-22-2015 03:02 PM |
IF + AND formula help | david_89_ | Excel | 4 | 06-11-2014 11:07 AM |
WHEN formula | agent007 | Excel | 5 | 02-06-2014 09:20 PM |
Need Help w/Formula | OSCAR MARTINEZ | Excel | 1 | 09-28-2013 05:39 AM |