Ability to set single-select formula value?

I was looking for a similar option, but I cannot find it either.

Basically, I want to set a single select field based on an if statement in a formula. But I cannot manually provide a State.

I expected that I could get the values in the database (aka, get all values associated to the single select), and get the 1st, 2nd, 3rd option, but I cannot get it to work. Is there anyway to set a single-select value from a formula?

It depends. Not using an if…then… construction, but you can use a formula to propagate a value.

1 Like

I expected as much, transferring values between entities is indeed very easy, it was the if then statements that I was wondering about.

Would be nice to have in the future to retain the low/no code philosophy

You can create the If/Then logic on a field in the database that triggers the automation. Then propagate the select field with that formula.

1 Like