I seem to have a 'ghost' in my sheet where only half of my automated workflow seems to work on any given day. My sheet (called a playbook) has half of the rows with =Today() date formula, and the other half with a hard-coded date; each night at 11:00pm PST my worflow copies the Today rows to a 2nd sheet (called a tracker)…
We're using Smartsheet to track project requests. I'm working to build "personas" to show the type of projects coming in based on the requestors job function. Is there a way I could use automation to add data from another sheet so that once we receive a request the automation can reference the requestor's job function and…
Hello, If I start an automation in the past, will it trigger on a date in the future? I want alerts to go start this coming Friday 2/25, and every two weeks after that. I set my automation up like this: Will this work?
Hi, I am trying to prepare reports that show certain information (eg, here are all the things that have happened in the last week/month/are coming up etc). If I do it as an automation in smartsheet, I cant seem to link certain columns without a linking the whole sheet (which contains sensitive information). In reports, the…
We have a column with expiration date that is put in manually by an employee with the rest of the data when received. Currently we have conditional formatting to highlight the products expiring within 30 days via the row turning yellow. We need a cell that will automatically count and display a value for all yellow…
Hello Team. I am setting up a sheet that would help track and act on over 3K documents based on their end dates. The two column I would like to work together are "end dates" and "expiration status". The "expiration status" column is a dropdown with the following choices: "Current" "up to 1 year expiry" "6 mos. expiry" "90…
Hi, Does any one know if there is a way to auto up date a subtasks dates when you move the tasks between parent tasks? The scenario is we have a course booking tracker and the PARENT task is the course instance and the SUBTASKS are the attendees. If we need to change the attends course slot we would like to drag to a…
Hi all, I have a list of people with emails in my smartsheet. Some of them left the company, how can I find out from smartsheet that their email not exist anymore and to mark them in the sheet? Thank you, Joachim
I'm not the best at the complicated formulas and need some help. I have 3 columns in play here. Submission Type (single select), Submitted date (automation added), and Due date (Date Field). If the requestor selects "Standard" in the Submission Type field, then I want the due date to be 30 days after the submission date.…
