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.
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.
User | Count |
---|---|
33 | |
29 | |
29 | |
20 | |
18 |