-
Lock all rows in a sheet
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 can I make sure the only ones allowed to add rows are admins? Thanks
-
Invalid automation
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 changed and no one has made any changes. Any idea why? I've tried to rebuild the automation and get the same errors.
-
#CIRCULAR REFERENCE with =SUMIF Formula
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 'Project Type' is 'Operational', this is the total house for the month of February." These the formulas I tried using:…
-
Automotion Trigger after 24 hours, not daily
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
-
Weekly Automation Notification when Event is Within Specific Timeframe
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 when that date is 90 days in the future, but the notification only needs to be sent once per record. I have the automation…
-
Copy to another sheet not working
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 have it copy to another sheet. I have also tested manually adding data, but it's not work. Can anyone tell me why it's not…
-
Auto Reply to Form Submissions
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 that they signed up for. Is this possible using workflows? I can't seem to select a contact in the "Send to contacts in a…
-
Formula to Capture Active Projects Assigned to an Individual ONLY
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 it so that it counts the number of projects by assignee IF the project status is one of the following: Not Started In…
-
Email response for forms
I have a few questions regarding forms. The form I'm setting up has a field for Email Address and if the user wants a copy of their responses, they're required to enter it again at the bottom. I tried a workaround where I toggled off the check box at the bottom where they can indicate they want a copy, and instead created…
-
How can I link two forms from two different sheets to put the answers on one singular sheet?
I want to be able to have two sheets with two different forms, but then I want the two forms to also have one sheet with the answers from both forms so that the answers are combined. Is that possible? If so, could you help?