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. 
 
Upvote 12
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos
6 comentários

I was looking for this feature as well. Thank you for beating me to it.

😁

0
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos
Avatar
Stephanie Westbrook

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!). 

0
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos

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.

0
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos

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

0
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos

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?

0
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos

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

0
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos

Folllowing List for Post: Custom Fields If/Then
[this list is visible for admins and agents only]

Alto
Didn’t find what you were looking for? Write new post