-
Parent function to auto-populate cells
Hi everyone, Wondering if someone could help me with a formula to auto-label cells. I'm creating a project tracker for my team on Smartsheet and have automation set up for approval process, and also so completed tasks are moved to a new sheet. The problem is, on both instances, the row itself might not contain all…
-
Automated workflow log
Hello, Is there a way to see a when an automated workflow is triggered in smartsheet? Specifically around the time sent and who the recipients were. When I check the activity log, I can only see when a automated workflow has changed. There has been a few cases where an automated workflow doesn't send out to the particular…
-
How you do get an automation to send an "Alert Someone" email.
-
Weekly tasks automation on task management
Hello, I'm optimising a task management sheet with automation and would like to know if there's a way to use automation to create a row? Some tasks are weekly, and it'd be great if they could be automatically added in every week, so the owner can get notified and mark them as completed each week. Is this possible?
-
How to automatically copy the approved documents into another grid or sheet?
Hi, I have a grid or sheet where the rows which document status is already "SPC-approved" need to copy or populate to another sheet called "Approved Docs". Is there a way where this Approved-Docs sheet can automatically copy or get those rows with "SPC-approved"? Please lead me to an idea like formulas, automation…
-
Move row automation/ Advance options
Hello, Is there a way to select the fields (columns) one wants to move to another sheet thru Move Row automation? One can use Advance Options> Column Visibility to select what to show for Alerts/Reminders and even in the approval workflow but it's not an option when moving/copying rows. Thanks
-
Need assistance asking people who haven't responded to a form to fill it out.
I have two sheets. One with contact information and another with the fields for a form. I have a formulated column in the contact sheet that compares information to the form sheet and determines if the person in the row, or a representative from their company, filled out the form, basically like a V lookup. My question is…
-
Automated alert containing a form to contacts outside of contact list in a sheet
Smartsheet Community, I am trying to create an automated workflow that will alert hypothetical meeting participants with an additional message containing a separate Smartsheet form link. However, I am receiving an error message that some contacts (emails) are not being notified in my inbox. These contacts are not part of…
-
How can I compare two date columns in an automated workflow?
Hi! I want to create an automated workflow which copies rows where two date columns are not equal to another sheet, how can I do this?
-
Automation between Smartsheet and Zapier: triggered raw on SS
Hi, I built several automation on SS that supposed to be triggered once raw updated. I did it via Zapier, though, it seems like sometimes it triggers and sometimes it does not. Every time I'm modifying a raw I save the changes to make sure the changes were saved. Anyone faced the same issue with Smartsheet and Zapier? Are…