Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Mar 28, 2023 12:04 PM
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!
Mar 28, 2023 01:11 PM - edited Mar 28, 2023 01:43 PM
Try this:
IF(date3, "Waiting",
IF(date2, "Extended",
IF(date1, "Completed", "")))
Mar 28, 2023 01:27 PM
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
Mar 28, 2023 01:42 PM
I think you'll need to send over a mock up so I can take a look!
Mar 28, 2023 01:49 PM
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
Mar 28, 2023 02:07 PM
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")))