How do I extract dateonly from system generated date columns?

Hello, I would like to create conditional formatting based on a system-generated date being more than 7 days in the past (my test is if it's less than 6, then trigger the flag). I created a helper column to do the math, upon which the conditional formatting is supposed to be set (if the flag is activated, then turn specific columns in that row the selected background color). However, when I populate the formula, I receive an error message (first snapshot). I tested the DATEONLY formula in the source sheet and received a different error message (second snapshot). Your help is appreciated.


Best Answer



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!