HELO AT ALL
I have an a colum winth name “Belt” , the colum is type Enum List with value as: 1-2-3-4-5-6.
I would like to show a choice of numbers based on the value of another column for example
If in the “OP” column the value is equal to “TP”, only the numbers 3,5,6 show the menu choice
thanks!!
Put in the Valid If of the Enum Field.
IF((([OP])=“TP”),LIST(1,3,5),LIST(1,2,3,4,5,6))
You will get the result. Similarly you can nest it or you can use IFS or SWITCH.
Best of luck.
perfect it works.
only problem is that the value in the “OP” column can change for example from TP to U2 how can I change the formula?
Thanks again
Hi @Cannone_Cannone !
Already I mentioned.
shahappsheet:
You will get the result. Similarly you can nest it or you can use IFS or SWITCH.
I can write it for you again but I think better you read IF,IFS,SWITCH. Then you can reconstruct according to your necessity.
In the above code/expression follow the underlines, black is CONDITION, green is result for true and red is for false. so you need to reconstruct here. However i am reconstructing for you again.
IF((([OP])=“TP”),LIST(1,3,5),IF((([OP])=“U2”),LIST(2,4,6),LIST(1,2,3,4,5,6)))
Already I have mentioned same thing can be done with IFS/SWITCH.
I hope it might help you.
Regards.
THANK YOU SO MUCH YOU WERE VERY KIND
Take a look at this article, hope it will help
https://help.appsheet.com/en/articles/961554-dependent-dropdown