I have been trying to find a formula to use that will let me count the total number of times a day appears in this column. I would like to ultimately put this info into a graph on the dashboard. Is th…
This is a simple request to allow visibility to see or display the full name of the destination sheet in an existing automation. Here is the use case: 1) I have created an automation whose action is t…
Is there a way to remove fields from the email request when setting up an approval workflow? Right now the approval request displays all the fields from the sheet and I would like to only display the …
Hello Everyone, I hope you had a great New Year! I have one (Source) sheet in which data is coming from Google sheet through data mesh and based on certain conditions it will transfer to the specific …
I have created an automation to send reminders for an Actions Log. The workflow is as follows: Run every day at same time If "notify" field is checked Various date conditions, eg due today, due yester…
Hey there - I'm trying to set up an alert redirecting users to my sheet to make sure everyone's using it and gently nudging them if they aren't. Here's the logic: IF they a) have permissions to access…
Hello, I hope you are well. I'm trying to find a way to collect information within a hierarchy on a sheet. I need to gather the last date for a column within a level of the hierarchy and display this …
I have set up a very simple control center program to generate two sheets for every freezer we have on site at my research facility. One sheet is meant to house active inventory while the other is mea…
Hi everyone, I have a sheet summary set up on every project, which tracks a number of weekly KPIs - e.g total tasks that week, total completed that week etc. The sheet summaries feed into a larger she…