Value to Text Formula

#1

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

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

#3

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

1 Like