-
Have two auto-number or rank by created date?
Okay, so I have been working this problem for a few days and it's officially making me crazy. Here's the problem statement: I have 3 intake sheets for different business units. Each has an Auto-Number column that has a prefix for the BU. I need to consolidate all of the attachments from those 3 sheets into 1 sheet. So on…
-
How do the automated notification attachment triggers work?
This should be straightforward information but I can't find it anywhere. How do the Automation triggers work for attachments? I assumed: An attachment is Added = New attachment An attachment is Changed = New version of existing attachment. But I just had an 'Added' attachment notification trigger when I uploaded a new…
-
Can you customize a Send as Attachment email subject line and body?
In attempting to add custom cell data in subject line of an SEND AS ATTACHMENT email, finding no luck. because unlike automations, with targeted rows, there is no true cell SEND AS ATTACHMENT can pull from. Am I missing something here? I have the helper columns in my sheet. I am in need of a monthly based export of REPORTS…
-
AUTOMATION SEND FROM: FULLY CUSTOMIZABLE MAIL DOMAIN
I've made an automated mail that is informing our clients about their project. But, the main issue is that the @smartsheet.com @app.smartsheet.com is often ending up in their junk or spam folder. So, my wish is that the Send from function could either be the mail adress of a contact in a certain cell or just a fixed value.…
-
can I get automated reminders for a 30 day check in when dates in my start date column are different
I have a column titled "start date" for each of my employees. I would like a reminder sent to a manager at the 30-day mark after their hire date.
-
How can I hard code a cell based on a trigger?
BLUF: When I create an Invoice, I need the cell-link to my live price data to be severed. I currently have a Price sheet for my products that is updated frequently. I use Control Center to create Projects, which includes an Invoice sheet. I have a dropdown on my invoice sheet to select a product, and then I use Index…
-
Why am I not getting reminders?
My reminder in smartsheet automation is set to trigger every day starting 12/05/2025 at 8am (gmt+1) and the condition is to send the reminder to the contact in the contact list if the reminder flag is set to 1 and the status is not one of DONE. Currently on the sheet, a task has the reminder flag set to 1 and the status is…
-
How to remove rows from a DataTable using DataShuttle when the source sheet has rows removed?
I have a DataTable that is currently populated by a DataShuttle. When I upload the source report to a sheet, the data gets added into the DataTable via DataShuttle. The DataShuttle is configured to "add rows when added to the source file" and "update rows as they change in the source file". The unique column identifier is…
-
Can one cell change cause workflows in multiple grids?
I'm trying to move data from two grids (Grid #1 and Grid #2) using workflows (When rows are changed) to archive grids when a cell is ONLY updated on Grid #1. Here is my setup and what the issue I'm having… Grid #1 has the column that is being updated. Workflow setup on Grid #1 to move the row when the cell is changed to a…
-
Date and Time Separator Formula
Hi Community, I'm looking for assistance with creating formulas in Smartsheet to separate a combined DateTime value into two distinct columns: one for the date and one for the time. "Date" Column: Contains both date and time values "Date Only" Column: Should display only the date "Time Only" Column: Should display only the…