-
can we create an automation or other method of removing columns
So I've been trying to figure out a way use have an automation transfer lines to a new sheet but then remove the extra columns. I'm ok using a helper column and then transfer it to a 3rd sheet but I cannot figure out a way to do it. Basically I have several sheets I want to create where a long sheet gets transferred to…
-
Creating a Form to Automatically Indent Tasks Under Projects in Smartsheet
I am working on a project tracker in Smartsheet and need help setting up a form that allows users to add tasks under specific projects. My main challenge is ensuring that these tasks are automatically associated with their respective main projects and indented correctly I'm struggling with the automation part.…
-
Workflow not sending emails
I have a very simple workflow that is not sending email when rows are added. I have been testing with me doing the entry and I don't get emails. My notifications and Automation Permissions are correctly set. Can anyone provide insight or suggestions?
-
Can "Send me a copy of my responses" be removed from Approval form
Hi Team, Can you please confirm if the below highlighted checkbox option can be removed from the Request Approval Action which leads to this Open Request form.
-
I'm not sure why my automation is not working?
The automation is supposed to have an alert going to a contact when a row is changed. It is based off of an equation that turns a cell "Red" when a date over two weeks has passed. This equation works but the automation is supposed to send out an alert when this change occurs. When testing with "Run Now", the message goes…
-
How can i make a row automatically get created and updated in one sheet as it is created elsewere
Hello world! I am trying to create a overview sheet that will be fetching values from two different lists. The two data sheets have a identifier number for each row in them, but placed in differant coloumns were only in one of the sheets is this identifier the Primary coloumn, so automating copy and paste row to other…
-
Smartsheets Save Error
Hi, I am currently having a repeated error in saving the changes that I make to my smartsheet. It first occured when I was manually triggering an automation through a checkbox in a column to move to another sheet to house the filtered rows. I was able to move 26 rows by manually triggering each row, but on row 27 it showed…
-
Automated emails not sending attachtments?
I have a simple automation set up where if Cell 1 has any value in it, It will send out an email to the requestor. Sometimes we have to include attachments but it doesn't always send. I already have it set up to send the information needed and I made sure attachments were checked as well. I also told all the admins "add…
-
How to deactivate Hyperlink in Automation alert?
Hello, I want to use the alert/email format that usually comes if you select one of the first two options. However, I don't the link to be hyperlinked/clickable as I don't want to provide sheet access to the users. The message-only option alert is not helpful as it's all text.
-
Automation for ever-changing database
The company I'm working for has a database that houses info for our external clients, the database is constantly being updated nearly daily, I want to create visuals on a dashboard for various statistics based off the columns of information. I used =countif and it worked well for some columns, but I quickly ran into an…
