Sign in to join the conversation:
I’m trying to use check boxes to search on a sheet. Is it possible to show or hide rows based on a check box entry? Regards Steve
Hi Steve,
Interesting!
I'd say yes but it depends.
Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)
Hope that helps!
Have a fantastic weekend!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
To show or hide rows based on a checkbox, I would say you have two options. Either you can pull a report based on that checkbox, or you can create a filter based on that checkbox.
Hi Andree
I’m trying to filter the account manager against projects allocated to them. I’ve added a formula in the Filter Match column to check boxes for projects against the account manager in the drop-down list showing in the ‘Select Name Below’ entry. When you select ALL in the ‘Select Name Below’ the check boxes are reset. What I would like to do is only show the rows that are checked against an account manager and reset to show all. Hope this helps,
Regards
Steve
Glad we got it working!
Have a fantastic week!
Andrée
Hi, "Fields marked with an asterisk (*) are required." is the very first line in the body of every form I create. I don't remember seeing it before (unless you missed filling out a required field; then you would see the message). Is there a way to turn it off or change it? None of my forms are in English so the message is…
I have a sheet that I pull into a report. The report I then want to use to make a stacked bar chart and put into a dashboard if I can. The columns I am trying to make into a stacked chart are: Lead, project and phase. The issue is that there are several leads and I need the stacked bar chart to show in different colors for…
I have a dynamic view setup for a dashboard that has NO restrictions And on the Sharing tab, I have a Group that I created as the additional share access to the view But the individuals in the Group still cannot see the data from the dashboard. Am I missing something? Because when I share the view to them individually…
