Skip to main content

Hi there,

I got trouble with using IF functions across Date field, currently I want my result is:

IF({Date field 1} is filled, then "Completed"), IF({Date field 2} is filled, then "Extended"), IF ({Date filed 3} is filled, then "Waiting")

How do I make this work? Thanks!

Try this: 

 

IF(date3, "Waiting",
IF(date2, "Extended",
IF(date1, "Completed", "")))

 


Hi Danny,

It's not work because every Date field has different date variables. But if that field was filled, which is either Completed, Extended or Waiting


Hi Danny,

It's not work because every Date field has different date variables. But if that field was filled, which is either Completed, Extended or Waiting


I think you'll need to send over a mock up so I can take a look! 


So look like this, I want to have another Field with formula, where 8879 Signed filled = Waiting for PMT, Ext Accept Date filled = Extended, Report Sent filled = Completed, 3 of that fields are empty = New, so I can get rid of the Status column and everything should be automatically whenever I filled the Date information

 


I might be misunderstanding but if this is what you are trying to accomplish then it should be possible with the formula I posted below! 


Here you can see the formula: 

IF({Ext Accept Date}, "Waiting",
IF({8879 Signed}, "Extended",
IF({Date Completed}, "Completed", "New")))

Reply