Formula to return boolean looking at multiple date columns

Hi

I need a formula that will look at three date columns and if any of them are date that isn't in the last 5 days, I want a boolean '1' returned.

This is what I've used:

=IF([Project Health RAG Last Updated]@row <TODAY(-5) OR(IF([Current Position Last Updated]@row <TODAY(-5), OR(IF([Next Actions Last Updated]@row <TODAY(-5), 1)))))

But it doesn't like it.

TIA

Cheryl

Tags:

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!