-
Custom Date Trigger - starts in past
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?
-
Producing automated reports with select info for weekly sendouts
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 products with expiration dates and we need a cell to count them in a range of days.
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…
-
Correct IF Formula for updating "expiration status" dropdown based on dates
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…
-
Subtask dates populate from parent
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…
-
how to find out if an email exists?
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
-
Add to a date if another column meets criteria
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.…
-
Timeline Variance indicators
Hi, I am new to using Smartsheet and was wanted to confirm a few things timelines related: Can Smartsheet create predecessor and successor dependencies (FF, FS, SS, SF) similar to MS Project? Does Smartsheet allow for WBS elements to be created through indent / outdent similar to MS Project? Can Smartsheet allow linking to…
-
Column Formula Changes - Change Cell Value
Hi Community, I have a column that contains a column-formula it has 3 options/ratings: "1-Great", "2-Not Good", "3-Bad", I set up an Automation that if it changes to 2 or 3 it should check a box in another checkbox column, but this is not working. I have another Automation that if it changes to a 2 or 3 it alerts soneone,…
