Column Formula to Highlight Rows from the Current Week

HenryWong ✭✭
edited 02/09/23 in Formulas and Functions

I am trying to create a conditional format to highlight rows from the current week (starting Monday), based off the Start Date column.

I have found a formula here but it wont let me convert to a Column Formula:


I added the conditional formatting but it is not working.

Additionally, sometimes we have a row without a date yet. Is there a way to add to the formula to ignore empty cells so that it doesnt give off the INVALID code?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!