Value to Text Formula

[Ryan_Whitney]

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

[JonathanBowen]

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]

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