Custom fields type Date - Conditions related to date today
Hi there,
we use plenty of custom field regarding the validity of a certain document or license. in this case, we would like to have a conditional marker that contrast that date with today. This can be really helpfull to know when a certain document is not valid anymore.
(or even know if the document will not be valid in the next 30 days.
Hello Jose Gacitua, thank you for bringing your case to us. This can be achieved using a formula custom field, I'm attaching two screenshots to illustrate the steps you'd need to follow:
Please, let me know if you have any additional questions 🙂
Also, I'm moving your post to the "How to" section 👍
Thanks Juan! this is a good approach.
just another fast question, do all the Date Fields turn red when the date is Past today? or only the "due date" from a task
Hi Jose Gacitua, I'm jumping in for Juan here.
It should be the due dates 👍
Lisa Community Team at Wrike Wrike Product Manager Become a Wrike expert with Wrike Discover
Lisa Wrike Team member Become a Wrike expert with Wrike Discover
Hi Lisa,
is there any feature request to set a date turning red, if it is not the due date? I will install the workaround, but would be great to indicate the date red directly (and even yellow if approaching the date).
Rohan V Community Team at Wrike Wrike Product Manager Become a Wrike expert with Wrike Discover
Rohan V Wrike Team member Become a Wrike expert with Wrike Discover