Creating a calculated field that displays a text message if a certain data range is met. | Community

Level 4

Question

Creating a calculated field that displays a text message if a certain data range is met.

Forum|Forum|1 year ago
November 14, 2024
1 reply
778 views

Hi All,

I need to create a project level calculated field to display a text message, if the data range falls within a certain range ie between 50-100% display text "Yes" if less than 50% display text "No". I also need to apply an 'IF' filter in the field that makes sure the field is only working on projects with the project statuses of In Progress or Complete.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

OmahaOmahaAuthor

Level 4

this is my current basic code that isn't working to display the text field I want: IF({sourceField} >= 50 AND {sourceField} <= 100, "Yes", "No")

OmahaOmahaAuthor

Level 4

Here's my updated code that works:

IF({DE:Source Field} < 50,"Less Than 50%","50% Complete"). Need to figure out had to add the project status as a parameter in this field.

Madalyn_Destafney

Community Advisor

Community Advisor

Hi there, try this (may have to tweak the parenths):

IF({status}="CUR","CPL"),IF({DE:Source Field}<50,"Less Than 50%","50% Complete")

If this helped you, please mark correct to help others : )