"Live Date" is 4 weeks from "Submitted Date"

Hi,

I'd like to set up conditional formatting to let me know if the "Live Date" column on my grid is indeed 4 weeks from the "Submitted Date" (Submitted is an auto-populated cell if that matters.)

I know I need a helper column, and I know how to do greater than, less than, equal to with an =IF statement, but how do I set the formula to account for the 4 weeks I want between "Live Date" and "Submitted"?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!