How can I incorporate 'IFERROR' in the below formula?


In certain circumstances there will be no date in both ' CAT - Date of Last Activity' & Date of Last Activity plus 7 years. Therefore I receive the error message #INVALID OPERATION. How do I add the 'IFERROR' function to the below formula to stop this from happening. I had a go but can't seen to figure it out. Thanks!

=IF(AND([CAT - Search Outcome]@row = "Found", [CAT - Date of Last Activity]@row <> "", [Date of Last Activity plus 7 years]@row < Created@row), 1, 0)

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!