Hi there, I'm trying to create a formula that would count all instances where a certain option is selected from a Multi-select drop-down and then it would subtract any instances if a certain category …
Hi all, I'm not even sure what to ask for, other than help. I have three key sheets that contain many of the same fields. I've (finally) figured out the Index Match formula to pull matching field in f…
Is it possible to prepopulate select data elements of a form from an existing sheet that contains the data. Example we have two sheets. Test Execution sheet (Sheet A) to manage and track testing and D…
Is there a way to validate when a sheet cell contains incorrect data and tell the user to correct it then WHILE STILL IN THE SHEET, without sending an email for the user to go back and correct it? My …
Hi everyone, I have been pursuing the forum but I can't seem to find the answer. For some background, my company had a team that set up our Workspace and sheets. One of my coworkers was also the admin…
Hi, I am hoping to see if I can get help with the following formula: =COUNTIFS([Area of focus]:[Area of focus], "HGIT", Status:Status, "Complete", OR([Status:Status] = "Approved"), [Channel:Channel], …
Hi All! I am looking for some help with a formula that I haven't been able to find in the community already. I'd like to roll up my Status column to the parent rows with the following conditions: Pare…
One thing that frustrates me the most is not being able to remove shared users easily. I know in the User Management section I can type in a e-mail address and have that person removed from all shares…
I'm trying to track new hires via work orders. I'm wondering if there is a way to create the number of rows indicated in a form submission on my tracking sheet? For example, should I indicate that I a…