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

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 476
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.

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