Formula to check box if cell contains Date OR Text

Melissa Shandy
Melissa Shandy ✭✭
edited 12/15/23 in Formulas and Functions

I have a nested formula that currently involves one check box be checked and three date columns to contain dates in order to check-mark as 'Complete.' However, I discovered one of the date columns involved may contain text from time to time (as a date is not always applicable to this particular field). How can I revise my formula to mark a file complete if this cell contains a date OR text? Please help! Formulas are not my forte! Also - the column name in question is 'Original Docs Returned Date' See photo example

Original Formula:

=IF(AND(([Collateral Perfected]6 = 1), ISDATE([Date Loan Checked Back]6), ISDATE([Original Docs Returned Date]6), ISDATE([Imaging Date]6)), 1, 0)


Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!