If Content > 0 Select Linked Content

Topic Labels: Formulas
704 0
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

I’m trying to gather information from employees about what teams they are in and how many hours they are available to spend on them that week.

I’m using a form to collect the names of the teams using a link to another spreadsheet where they can select from a list of all the teams. They then have to input the number of hours they have available to spend on that team further down. I wanted to add dependencies so that these would only show once you have selected a team but that’s not possible so I am trying to find out if I can select all of the teams they are in by checking if the hours they have inputted for a team are more than 0.

Any ideas would be greatly helpful thanks :slightly_smiling_face:

0 Replies 0