A formula field cannot change a single-select field. A formula field can be combined with an automation that updates the single-select with the formula result.
IF(
FIND("⏳", {PM Time Left}),
"not done",
"done"
)
A formula field cannot change a single-select field. A formula field can be combined with an automation that updates the single-select with the formula result.
IF(
FIND("⏳", {PM Time Left}),
"not done",
"done"
)
Fair enough, thank you for the formula!
I can use the formula field for this instead of a {PM Status} single select and achieve the same result, just need to change my automations around. I have an automation set up for when a record enters a view, ie: "Done" from "Not Done" it clones itself and a few calculated fields to make a new record with a new service date
ex: 3/25/23 marked as done, with a calculated service interval, the automation runs and makes a new record with a date 90 days in the future for its next service appointment.
I'm trying to make the same result happen through an automation when the same data is entered via a form, but because it's making a new record and not changing an existing record, it's causing a bit of trouble. It generates a new record rather than changing things on the existing one and as such, the automation fails, gotta figure out a way to get the same results from a form entry. Any thoughts?
