-
Best practice question re primary column for RAID log sheets: ID number or name?
Hi, everyone. I have different sheets for elements of my RAID log (reasoning for us being decisions needed more/different columns than risks, etc.). However, we are split on if the primary column should be the ID number (e.g. Action ID, Risk ID, etc.) on each sheet or the actual name of the item (e.g. Action Name, Risk…
-
Cascading Dropdowns
Is there a way to do the cascading drop downs without having to have multiple columns? I know there is away to display different fields on a form, but I only want to restrict the items displayed in a single dropdown based off a response in a different column. For example: If you have a Category dropdown & a SubCategory…
-
Is there a way to copy a template into multiple workspaces?
I have project artifact templates that I have created for our team in a shared workspace. However, knowing that there is the potential for people to change, delete things, etc., I want a copy of this template in my personal workspace so that, if it gets accidentally deleted, etc. I always have a spare copy. At this point,…
-
Countifs with checkbox, blank date
Hello, I am trying to use the countifs to count a reference sheet when a checkbox is checked and a date is blank. I know the first part is "=COUNTIFS({referenced sheet checkbox}, 1," I'm just not sure what to use for the second portion. I think the closest is: =COUNTIFS({reference sheet checkbox}, 1, AND({referenced sheet…
-
Report sort order
I have a report, linked to a sheet that I'm struggling with the report sorting. Within the sheet, I have rows numbered by a category type, and sorted within each category. The corresponding report is not reflecting the same sort at the sheet. I have re-loaded the sheet, refreshed, signed-off/on and still no luck getting…
-
Automation Alerts work sporadically
Hi I'm working on automating alert notifications from Form submissions via email, Teams Channel and the Teams Bot and so far the Channel is the only one that seems to work consistently. In all scenarios in my testing, as you'll see in my screenshots of the workflows, my email is associated with the SME listed and I list…
-
transferring an individual sheet from a business to an individual
I am trying to transfer ownership of a few sheets from a business account to an individual account. Keep getting the following error when he tries to accept the ownership request. Same result if he asks to take ownership from me on my end. Ideas?
-
Automated Email of "When Date is Reached" contains the word "Message"
Hi, Does anyone know why I'm getting the word "Message" when I receive a "When Date is Reached" autoamted email ? Below is how I set up the automation and there is no word "Message"
-
Can a sheet manage user access at row level?
Hi, I have a strange scenario where we have established a sheet which will be accessed by a wide variety of stakeholders. We have one group who need to access the majority of information, but we want to be able to lock that group out from particular rows within the sheet. Is this possible? thanks.
-
Is there a way to add an image to an update request form?
I have a column in my sheet that is called "Image" that i currently upload an image to, however i can't see anyway to upload an image using the update request form. is there any way around it?
