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 ...
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 e...
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
