hi. I want to do a dropdown list of suggested value for a column that is taken from another table, and is conditional.
the issue is that I want to do it on Date values (not Text) can it be done? how? i saw this, and this is the most relevant but I could not make it work for me, yet… https://help.appsheet.com/expressions/using-expressions/suggested-values-for-a-column
where do i write the constrain? in the valid if or the formula?
second q: can it be done on virtual column? if so what do i write in the formula (if the constrain is need to be in the valid if)
Thanks! please help, I am in a loop regarding this for a while:) Ravid