Help

This Product Ideas board is currently undergoing updates, but please continue to submit your ideas.

Value to Text Formula

cancel
Showing results for 
Search instead for 
Did you mean: 
Ryan_Whitney
5 - Automation Enthusiast
5 - Automation Enthusiast

I’d like to request a product enhancement to allow formula fields to take a value, and assign a plain text input on a formula field. Currently, you can go from text to number, but not the other way around.

Use Case: We currently calculate date a project is overdue. We’d like to take that number and auto-update a formula field called Timeline Health.

  • If date overdue is < 0, enter Healthy
  • If date is 1-10, enter At Risk
  • If date is > 10, enter High Risk
2 Comments
JonathanBowen
13 - Mars
13 - Mars

Hi @Ryan_Whitney - just to clarify - do you want the Timeline Health field to be the result of a formula, i.e. auto-populated? What do you mean by “enter Healthy” etc?

JB

Ryan_Whitney
5 - Automation Enthusiast
5 - Automation Enthusiast

Wait, nvm, this is already possible. Sorry for the confusions there!