-
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?
-
Automatically Create Report with Single Row Data?
Hello, Is it possible to use Smartsheet to automatically create a single row report and mail a viewable link? Use Case is similar to getting a package tracking number where the end user can view realtime progress on it with the unique link/identifier Below is the idea I have sketched out, but I have not found a way with…
-
Copy row automation errors - does it reset?
I have automations setup to copy completed tasks to a separate sheet. When the sheet fills up and can not accept more data i received a notification that these automations cant run. So i went into the sheet and deleted or moved rows to additional sheets as needed for my processing. This freed up the sheet to accept more…
-
Alert Someone Notification Not Working
I have set up an "alert someone" notification that is not working. I have edited, deleted, deactivated and re-activated it with no solution. I set up a two sheets around the same time, one works and the other doesn't.
