Combining IF(AND statements with Dates

Hi -

I am trying to build a combined IF statement that takes a last contacted date and a last participated date and if both are true will output a status of "available". If not, it will be "not available". Separately, I can get the a formulas to work for each date, but once I combine the formulas, it fails.

First date formula:

=IF([Last Contacted]4 <= TODAY(-30), "Available", "Not Available")

Second date forumla:

=IF([Last Participation Date]4 <= TODAY(-90), "Available", "Not Available")

Combined:

=IF(AND([Last Contacted]4 <= TODAY(-30), [Last Participation Date]4 <= TODAY(-90), "Available", "Not Available"))

Thanks in advance for for any help!

--Brad

Tags:

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!