I'm trying to automate the unlocking of multiple rows, triggered by an approval request being approved. Reason being: want to force users to submit a proposal before moving on to the next project step…
I'm keeping a portfolio of my teams projects (150+). Once a week, I'd like to send out a request update for each person to update their assigned projects. I can't figure out how to send out the reques…
Morning, I need to be able to stop anyone other than the admins of the sheet from adding rows but I also need to give users "commenter" status because I want them to be able to use the comments. How c…
Some of my long-used automations are becoming invalid, stating the end user who is to be notified of something that has occurred as "unsubscribed" but that isn't the case. No email addresses have chan…
For each month, I am trying to sum up data depending on the type of project it is. For example, "If the 'Project Type' is 'Strategic', this is the total hours for the month of February," "If the 'Proj…
Hi, is it possible to set an automation to run 24 hours after the field is changes instead of once daily? I want to give the person a 24 window to change the option picked. Thank you
Hello! I'm trying to work out an automated notification that is triggered weekly. We have a date field that will house a calculated date based on another field. We want a contact field to be notified …
Hi, my goal was to copy from excel to a sheet, but that is not working for me, so I decided to try the copy to another sheet automation. I would like to import new data from excel into a sheet and hav…
Hello Team, I was trying to setup automatic replies to people who enter their email and select a certain timeframe. I would then like to send an automatic reply with information regarding the session …
I'm currently having trouble figuring out how to capture the number of status specific projects assigned to an individual. I've attempted the "COUNTIFS" formula many times, but can't seem to configure…