Check a Box, Reference Another Sheet, Days from today



I am working with 2 sheets. 1 sheet is providing a summary of the other sheet. I need assistance with creating the formula.

On the summary sheet, I want to check a box if there is a row listed on the other sheet with the same city and has a scheduled date of 6 months from today.


=IF({Site}, =Site@row, {Scheduled Date}, @cell <= TODAY(180)), 1, 0)

Thank you for the help.


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!