Field Logic in Dynamic View
Answers
-
Hi Silvia,
Yes! You can use the Restrict View by Sheet Filter option from the very first page when editing your View, at the bottom of the General tab.
You would need to first set up the filter in the source sheet to show everything except when the Job Status is "Complete". Then once the filter is in your sheet, you can use this as a filter on your View.
Let me know if you have any questions!
Cheers,
Genevieve
-
thanks @Genevieve P ... Question; if l setup a filter in the source sheet to show everything but the complete status, this status will not show in the sheet, correct??
ETA
I just tested it and unless the settings are selected to Restrict View by Sheet Filter, the Dynamic View still shows the sheet as unfiltered.
Thanks Genevieve!
-
Sounds like you sorted it out! Glad you got it working 🙂