-
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…
-
IDEA: Populate Available Field Names After Typing Double Curly Brackets {{
When I create custom messages in Automations, such as approval emails, I'd LOVE to have the system give me a list of possible field names to use after I type in the double curly brackets '{{' This would work exactly like Dropdown lists do, with their pre-populated lists.. I'm certain there are other locations where this…
-
Merged: Auto Suggest column names when using double curly brackets in automations
This discussion has been merged.
-
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…
-
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…
-
Outlook Email to create new Rows in a Smartsheet
Company uses Bluebeam Revu software to create drafting check sessions (adding notes to PDF's). These session come from the same email address every time and can be automated to be sent to an email. I want to try and get these emails to go to a smartsheet row. what would be the best way to achieve this? My company uses…
-
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…
-
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…
-
Automation Not Working
I have a sheet set to notify myself and another user when ANY CHANGE is made to the sheet. Neither of us received the notification. Any suggestions on why this is not working? It has been a while since this form was used, but it worked previously.
-
Batch add/update time entries?
We are trying to update all users’ timesheets programmatically, which will involve tens of thousands of records in total. According to the Resource Management API documentation, time entries can only be updated one at a time. Is there a way to batch update multiple records at once? If I’m not mistaken, the API rate limit…