Custom Fields If/Then
Request for if/then values within a custom field drop-down menu.
For example, if there were two custom fields: A and B.
If I choose x for A, then I only can choose y or z for B.
If I choose q for A, then I only can choose p or r for B.
I was looking for this feature as well. Thank you for beating me to it.
😁
Welcome both to the forums! 🙌 We have similar functionality on Requests, I can see how it would be useful for Custom Fields as well.
@Morgan Thanks for adding this! I went ahead and renamed the title of the post just to make it easier for others to find (and upvote!).
Yes it would be nice to have this. I created custom field to calculate the days late for a given task but that only help when the task is actually completed. It is difficult to measure how late a task is when it is not marked as completed yet.
If (status = 'Active') then (Today() - [Due Date]) else ([Completed Date] - [Due Date])
For now I will have to continue to export to excel and perform this calculation there.
Hi Justin Karchner, thanks for reaching out! 🙂
Have you tried using Calculated Custom Fields for this? They allow you to make calculations based on data from other Wrike fields. The calculated custom fields feature is represented by the “Formula” custom field. Please let me know if they can help!
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,
I do use the Calculated Custom Fields, but I cannot create the IF statement that I would need, unless I am not seeing how to do that.
How would I go about creating a formula to show the number of days late a task is, if it is still active, but then also have it show the number of days late the task was when it was completed?
Justin Karchner That's not possible currently, but you can set up separate calculated fields for those two actions you're describing - as I understand, you're doing that already.
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