I need Help with a function

Im currently in the proccess of switching from excel to smart sheets i need a formula that will change the color of a cell based on #days before a start date of a project. essentially if a task is not completed like a dumpster isnt ordered and the project starts in 3 days the cell turns red. Im guessing the excel function will not work in smart sheets.

Thank you for your help


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!