-
Change Terminal Automation Actions to Non-Terminal
I suggest changing terminal actions such as the "Record a date" and "Change cell value" actions to non-terminal actions. There are many times when I would like to record a date or change a cell value before the next action in the automation occurs. Having separate automations for these actions and ensure the proper order…
-
Date Formula
Hello! I have created a sheet, that based on the month, a workflow will be triggered to send an email out on a certain date. For example, if the month is August, Sept or October, an email be triggered to be sent on 12/15/23. If Nov, Dec or January is checked, then the email will be triggered to be sent on 3/15/23.…
-
Dates to populate values in associated cells
I'm working on a training sheet where every year you work its worth a certain amount of points. What I would like to achieve is after the date (1) is repeated annually, the "Years Served" (2) column adds +1. As this is done the "Year" column (3) is updated to a certain value of points based off of "Years Served" I believe…
-
Setting up notifications when one column has all rows checked.
Hello, We are trying to setup a notification to a person in our company through Automation. We want ALL boxes to be checked on all rows for different topics before the notification is set. See screenshot. We would want all "Processes" to be checkmarked for Month 1/2/3 in order for one email to go to a Manager stating- it's…
-
Bridge - SharePoint Integration Error: When field from the source sheet is blank
Hello, I have created a bridge integration which pushes various fields housed in a Smartsheet to a SharePoint list. I have successfully done this on multiple format types, including text, numbers, checkboxes, etc. I have incorporated errors in my Bridge workflow when pushing various Smartsheet columns that are blank. The…
-
Automation: change cell value to a date when triggered
Hello, I was wondering if it is possible to approach it differently since 'change cell value' to a date is not possible, it is only possible with columns: text/number, dropdown and checkbox in my case. I wanted to have an automation when a person which could be one of two following: contractor or permanent and I want it to…
-
Merged: Add Attachments to Automated Email/Workflow
This discussion has been merged.
-
SmartSheet Proofing of dozens of files
Is there a way to bulk submit a few dozen files for proofing? Typically, this would be PDF engineering drawings. I want to start doing this within SmartSheet, but don't want to do them one at a time. Alternatively, can an automation be configured to copy the file for proofing and submit it to a group or group for review?
-
CHANGE CELL IF CRITERIA ARE MET
Hello, I have two sheets, the blue one is (Sheet 1) and the yellow one is (Sheet 2). Sheet 1 are data that I got from a form, which includes the date schedule slot and timing. Now, I want in Sheet 2 to show if the date and time is chosen the status in Cabin 1 - Status is not "BOOKED" not Available. How can I do that?
-
Workflow Automation Not Applying to Child Rows
I'm sure I'm missing the simply answer here, but my automation is set up to check a box and turn a row red when a due date is within the next 7 days. It works, but only on the parents rows. I need it to work on the child row tasks. I would prefer if there was a way for it to ONLY work on child rows, but I'll take an…