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 8
6件のコメント
Spot On Innovative Approach Stellar Advice

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

😁

0
コメントアクション Permalink
Spot On Innovative Approach Stellar Advice
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
コメントアクション Permalink
Spot On Innovative Approach Stellar Advice

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
コメントアクション Permalink
Spot On Innovative Approach Stellar Advice

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
コメントアクション Permalink
Spot On Innovative Approach Stellar Advice

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
コメントアクション Permalink
Spot On Innovative Approach Stellar Advice

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
コメントアクション Permalink

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

トップ
Didn’t find what you were looking for? Write new post