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