Date Comparison Formula Help
I am a SmartSheet novice, but my team is used to base tracking in SmartSheet. I would like to set up conditional formatting that highlights if a site's planned schedule puts the site at risk.
I would like to compare two columns: "Construction Schedule: Turnover to Retail Date" against "Exterior Installation: Scheduled Date".
If the Construction Schedule date is less than 14 Days after the Exterior Installation date, I would like for the checkbox to become active.
I don't understand enough about the formatting of formulas to make this happen.
Help Article Resources
Check out the Formula Handbook template!