Formula to place a date in a cell that is greater than a date in another cell by "x" lead time

Hello again community,

Just wondering if somebody knows how to write a formula that could look at a date in a date ordered column and place a date in another column that is greater by 30 days. From this point, I have an idea to have a formula tick a box based on whether this date is today and then have a conditional formatting rule that colours the row bring attention and show urgency.

Any help or insight would be greatly appreciated :)

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!