This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
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...