Calculate difference between dates if populated, return a different result if not


Hello, newcomer here!

Trying to work out the best way to calculate the following please:

If Date X = blank, return result 'overdue'

If Date X = populated, calculate difference between Date X and Y

Following on from that, I need a following column to return Yes if date is <1, or No if date is or overdue.

Thanks in advance!!


Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!