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?
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:…
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…
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?
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…
I have read several posts that suggests that this is not currently an option. I have a sheet which contains a list of evaluations. Sometimes we have to complete a second, or even third evaluation of the same person. Each row represents a person and their evaluation. If we have to do a second evaluation then much of the…
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…
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!
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…
I have two sheets that utilize the auto number column for tracking two different things. sheet two has all of the data sheet one has, including the ID that is autogenerated on sheet one (manual input into sheet two), but it also has additional columns such as the autogenerated sheet two ID. I wanted to create a workflow…
