Hi, I’m using the Valid if expression:
SELECT(Whian Whian[Task Description (What needs doing?)], [Status]<>“Completed”)
Which works correctly in giving me a drop down menu list of task descriptions. However, once that task has been completed and the status changes I want it to either automatically delete that entry from the list or cross it out.
I do notice that if I go to a detail view of the row that now has the invalid entry it comes up with an error message for that entry but in a table view it shows nothing.
I’m not sure if there is some kind of formatting that I can do to highlight a row on a table that has an invaild entry.
does anyone have any suggestions?
thanks
LinkedIn
Twitter
