-
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.
-
Export only new rows from form submissions to excel
I have been searching for an automated way to get this done. I have a pretty intense (for me personally) form that my coworkers use to track a number of things that I measure. I am pretty married to my sheet and have a number of automated workflows running with it as well. There are about 48 columns of data including index…
-
ALERT SOMEONE
I am having problem to setup automation to alert someone. I have a column that shows 4 rows and another column that shows when the Alert someone should be sent out: Citrix/Network/PC Comm 1 - 3 weeks [column Communication Released Date: 02/17/22] =PARENT([Network Migration Date]@row) - 21 Citrix/Network/PC Comm 2 - 2 weeks…
