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 ide…
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 inten…
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…
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 fi…
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 t…
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 b…
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 th…
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…
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 …