Changing Drop Down Value Based On Current Date?
I am trying to change the drop down value on my Health column based on the current date. Is this possible?
ie. If the start date value is in the past, the health column changes to "At Risk" which is one of the drop down choices.
Answers
-
Try something along the lines of...
=IF(TODAY() > [Date Column]@row, "At Risk", IF(TODAY() = [Date Column]@row, "Due Today", "On Track"))
.
Without all of your criteria and possible options in the dropdown, that's about the best I can give you.
Basically you would use a nested IF for each option in the dropdown using the above format.
The above says that if the date in the date column is in the past then "At Risk". If the date is equal to today then "Due Today", all others are "On Track".
Obviously you will need to modify it to fit your sheet, but there's a place to start.
-
Help Article Resources
Categories
Check out the Formula Handbook template!