Creating Column

[spandy34]

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 @tamerj1 @goncalogeraldes 

[Greg_Deckler · Accepted solution]

@spandy34 Try:

Column = IF( [ScheduledDate] <> BLANK() && [ActualDate] = BLANK(),"Needs Action",BLANK())

[Greg_Deckler · Accepted solution]

@spandy34 Try:

Column = IF( [ScheduledDate] <> BLANK() && [ActualDate] = BLANK(),"Needs Action",BLANK())

[spandy34 · Accepted solution]

Really appreciate your help . Thanks worked .