-
Automate Copy/Paste Special in same sheet or to another
We have "live" metrics collecting data from multiple departmental sheets, and display them on a dashboard. Works beautifully. The challenge is, we need to save each metric into an historical sheet, which means we need to store the numbers as static numbers. Copy/Paste Special accomplishes this — but it has to be done…
-
How can I copy a row from sheet with cell links to antoher sheet? Reccuring workflow not working
Hi all, I am trying to COPY rows automatically when a project owner name is changed from the original sheet to a destination sheet. The original sheet has cross links to another sheet and hence, I tried to use recurring workflows. Neverthless, not able to find the desitination sheet in the search box. I have tried to write…
-
Date format in automated emails
Hi there, I've set up an automation on a sheet and noticed that the dates in the automated emails are in the incorrect format, despite me setting my regional preference in the settings. I have the dates set up in my settings for Brazilian format (i.e. DD/MM/YY) and this is how it shows in the Smartsheet itself. However, I…
-
Automation from dropdown list
Hi all, I’m building workflow automation for tour requests. When a requestor selects items from a dropdown list, the responsible people should be notified. Attached is a picture of my automation. Only the first item (Metal) triggers notifications, but not the second or third (Tissue & Anatomical). Any suggestions on how to…
-
Smartsheet Automation received and submitted by user, but not appearing in sheet
Hi there, I'm hoping you can help with an issue I'm having with a sheet. I created an expenses sheet. Once the expense is submitted, via form, to the sheet, I can check a box, click save, and it sends an automation request to a budget manager to approve or decline the expense. This is in the form of a check box. The user…
-
Copy Rows with Hierarchy
Hi, I have a sheet with hierarchy once one is marked delivered the row with the hierarchy under it moves to a purchased sheet. Once it is in the purchased sheet I would like it to copy rows that are blank with the hierarchy back to the main sheet. The automation is working if I force it to run but it is not working…
-
Connect WordPress form to Smartsheet for Record Keeping
Is there a way I can populate a Smartsheet with entries from a WordPress form? We use the Gravity Forms Addon
-
Form autofill
We use a Smartsheet and form to manage requests for free tickets to our shows for internal staff. They fill in their name, email, position in the company, show they want to see, first and second choice dates, and number of tickets requested. When the application is approved, they are notified, and the information is sent…
-
row level update request does not work for one specific user
Dear Community, Today I faced a very interesting (for me at least) situation: My automation workflow sent an update request to a user and when this user tried to open it, received a messaged at the browser that his user was not recognized. What was holding my attention as well was that the opened link showed as well at the…
-
Message Includes: All Non-Blank Fields
Would like the option to make a message include "all non-blank fields" as we have large intake forms and sheets with 150+ columns, and our only options for automations is All Fields which is so large we have to send as an update request, or Select specific fields to cover all possible scenarios which still can be 80+…