Adding text to a different column when a enum value is selected

David_B
Participant IV

I’d like to be able to add text to a different column than the column the enum is set to.
For example when “Depleted” is selected from the [Status] column enum, I’d like it to also show “Depleted” in the [Depleted] column. I’ve searched the help files but cannot seem to locate a way to do this simple change.

0 6 467
6 REPLIES 6

You could do that for example with the initial value IFS([Status]=“Depleted”,“Depleted”)

To add "Depleted to a different column?
Like:
IFS([Status]=“Depleted”,[Depleted] = “Depleted”)
This gives me the error:
The expression is valid but its result type ‘Yes/No’ is not one of the expected types: Enum

Instead of using “=”, you need to use comma.

This makes my [Status] option in Edit go away.
My goal is to be able to Edit items and when Depleted mark 2 columns as such.

David_B
Participant IV

I think I accomplished another way of doing what I hoped. Thank you for your time.

If you use it with the initial value option, you can modify it as well.

Top Labels in this Space