Currently, BLANK() function returns true even for the cell where the value is 0 (zero). It will be more useful if the BLANK() function returned true strictly if the cell is empty.
Hi @Shilpa_Wymer,
Would you elaborate a little more on your question, by mentioning what kind of columns you have in mind? Will be able to help you based on that.
@Jayme_Richardson, the following formula will work. Please note, “First”, “Second”, “Third” are the field names. Also, it assumes that you have a process where dates are entered into the fields chronologically.
IF(Third, Third, IF(Second, Second, Fir...
@Tyler_Dunlap, the following formula will do what you want.
IF({Finish Date}, DATETIME_DIFF({Finish Date}, {Start Date}, "days"),DATETIME_DIFF(TODAY(), {Start Date}, "days"))
There are three things that were solved.
Compare the date field isn’t blank...