The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.
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...