Custom Fields If/Then

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

Do we have an update on "IF Statement" can be incorporated into a Function-Type custom field?

Hi Joseph Ricciardi, thank you for your question. At the moment, we don't have updates to share on this suggestion. Please, rest assured that we will keep you informed in case any changes are implemented 👍

If you have any other questions, please let us know 🙂

hi, is there any update on the IF function in Fields? Would be super useful for more complex tables

Hi Grazka Meller, welcome to the Community! Thank you for expressing your interest in this suggestion. We don't have updates to share about this one at the moment, however, we will keep you informed if there are any changes 👍

Also, please allow me to mention that you can check our New to Community forum to discover all the resources you can find in our Community 🙂

We would also benefit from this.  Is there any update?

Basudha Sakshyarika Community Team at Wrike Wrike Product Manager Become a Wrike expert with Wrike Discover

Basudha Sakshyarika Wrike Team member Become a Wrike expert with Wrike Discover

How does this have only 23 Upvotes? This was literally something we asked about during the sales process. I wanted a tool that would allow us to use logic. And was disappointed to see that you can't do If/this and/or statements. 

Adding this functionality would be a game changer.

Tiffany - totally agree

Looking for this feature as well

Hello. Is there an update on this functionality? 

Hello, looking for an update as well.

Hi folks! Thank you for your continued interest here! While we don't have any updates as this feature isn't currently on the roadmap, we've shared all new feedback from this thread with our team. 

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

+1 

Use case: Show me elapsed time except when the project/task is completed. Example: If(status="Completed",[Completed Date] - [Start Date], today() - [Start 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

This thread has been open since 2017. I assume there are no plans at all to introduce this type of logic? I would be grateful if you could confirm.

Wrike tables are essentially pretty looking excel tables that provide colour and a visual appeal. Whilst I acknowledge that Wrike is not a replacement for Excel, it would however be beneficial to have if then else logic within the existing custom fields, for example, if custom field 1  = A then custom field 2 = X or if custom field 1 = B then custom field 2 = Y. Thanks

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