Is there a way to hide a table if it is empty?
For example, I have a list of tasks, but they’re all marked done.
I’d like to do something as follows:
If there are no undone tasks, show “All the tasks are done.” If there are tasks still undone, show the table.
Something like:
=If (Count(TASKS.Filter(Done=“True”)=0, “All tasks are done,” TASKS.Filter(Done=“False”))
However, this doesn’t return a table, it just returns an in-line list of tasks. Is there a way to return a table?
I can also see using this kind of filter to show tables at the right time, to the right person, etc…
Best,
Maria