Forum Discussion
Solved
Creating Column
Hi I want to create a column called 'Needs Action' where a 1 is inserted if Scheduled Date field has a date in it and the Actual Date field is blank. Can anyone tell me how I would do this please ...
spandy34 Try:
Column = IF( [ScheduledDate] <> BLANK() && [ActualDate] = BLANK(),"Needs Action",BLANK())Really appreciate your help . Thanks worked .
spandy34 Try:
Column = IF( [ScheduledDate] <> BLANK() && [ActualDate] = BLANK(),"Needs Action",BLANK())Really appreciate your help . Thanks worked .