Is there a way to conditionally hide a row? I want to hide rows based on an answer in a cell in its row. I have a client list but want to hide the ones that are not active. So if o2 = ‘yes’ then I want row 2 to be hidden, and if o3 = ‘no’ or blank then I want it shown…
I want to keep the information in the remaining cells (last contact, what type of client, etc) for future follow up and info but it doesn’t need to be seen on a daily basis.
—–
Chris
Yes. Use filters. Simply filter the table based on the value of that column. I talk about filters in yesterday's tutorial: https://macmost.com/single-tables-filters-and-categories-in-mac-numbers.html