Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

If Content > 0 Select Linked Content

Topic Labels: Formulas
384 0
Showing results for 
Search instead for 
Did you mean: 

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