"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"?
Tags:
Answers
-
Hi!
Could you do =if([Live Date]@row=[Submitted Date]@row+28, "True","False)?
The 28 would account for the 4 weeks (4*7=28)!
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!