-
Is there a way to set up automated reminders for just specific columns in a sheet?
I'm working on a sheet that has lots of columns, so want to create an automation to remind people to only update specific columns on a biweekly basis. Is this possible?
-
Smartsheet checkbox automation triggers email notification to email in field
Hi Smartsheet Smarties! I need your help! I have a Smartsheet with a form that people fill out requesting time off, including their email. There is a checkbox (not included in the form) that is to identify management approval. I would like to set up an automation that would email the person who filled out the form (field:…
-
email automation for children
Hello, I am interested in creating automation to send an email when a date is past. I would like the automation to focus on the lowest level of hierarchy to assess whether the date has passed. I intend to make one assumption that a parent row always has "Knowledge Sessions" to indicate the automation follows. Notice the…
-
How to update picklist column
Hi, Currently I have a few columns which contain individual list items, but when I send an update through the API they appear as a single string Is there a specific way I need to be sending list items so that each item appears individually?
-
Running job to date hours on a project per task code?
How can I have a running total of Job hours to date per task code display on a sheet that shows actual hours vs estimated hours? The problem I am running into is: I have a weekly time sheet that is filled out for the employees on a particular project. The time has to be separated out by Straight Time, Over Time, Double…
-
Auto Add/Subtract to Inventory
I am attempting to create an inventory sheet for my business and was wondering if there is a function to automatically add and subtract to a number in a cell. Maybe something similar to say a button that +1 or -1 when clicked. If this is not available what would be the best way for my staff and I to updated inventory…
-
Setting a reminder - automation not working
Hello, I am trying to set up a reminder to go out three days prior to the "Start Date" - I've tried using the trigger for rows being changed as well as dates changing, but nothing seems to work. See below sample. What am I doing wrong? Thank you in advance!
-
"Copy Row" Automation workflow creates duplicates in final sheet
I have one sheet where we catalog all the estimates that we do. Each row is an estimate and there's a column that has the contractor for that job. I made a workflow where this sheet copies each row that is marked with a specific contractor and sends that copy to another sheet I made to catalog that specific contractor's…
-
30 days past due warning
Hi, I need to find automation or formula but not sure which. I have a column of due dates, I need a another column to say "30 days" if due date column is over 30 days past due. Any help is appreciated. Thank you Kim
-
Automation emails
Hi, I am wondering if someone can assist me with why I am getting notified 7 times for an automation I have set up. This is the automation I Have set up and when I test it out, I get 7 emails stating the same thing.
