Need Help with a Formula
I'm trying to create a formula that says if the date in the "due date" column is between 60 and 90 days from today, mark yellow
I've tried a few things but can't figure it out. Can anyone help?
Best Answer
-
@Mrawes great to see you are working with Smartsheet please try.
=AND([Due Date]@row >= TODAY() + 60, [Due Date]@row <= TODAY() + 90)
If my comment helps you, I appreciate a 💡
Kind regards
Nico | LinkedIn
CEO | Lighthouse Consultings
Lecturer in Business Information Systems | DHBW
________________________________________________________________________________
addvalue@lighthouseconsultings.com
We offer Licenses - Training - Solution Engineering
🔴 GOLD Smartsheet Partner _______________________________________________
💯 SCALEABLE Solutions Engineered by Lighthouse Consultings
We Don’t Just Implement Smartsheet; We Revolutionize How You Manage, Plan, And Execute.
Answers
-
@Mrawes great to see you are working with Smartsheet please try.
=AND([Due Date]@row >= TODAY() + 60, [Due Date]@row <= TODAY() + 90)
If my comment helps you, I appreciate a 💡
Kind regards
Nico | LinkedIn
CEO | Lighthouse Consultings
Lecturer in Business Information Systems | DHBW
________________________________________________________________________________
addvalue@lighthouseconsultings.com
We offer Licenses - Training - Solution Engineering
🔴 GOLD Smartsheet Partner _______________________________________________
💯 SCALEABLE Solutions Engineered by Lighthouse Consultings
We Don’t Just Implement Smartsheet; We Revolutionize How You Manage, Plan, And Execute.
-
Yes I was able to get it working. Thank you for the help.
Help Article Resources
Categories
Check out the Formula Handbook template!