-
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…
-
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…
-
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…
-
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.
-
Using Automations for Filtering a Daily Refreshed Sheet from External Doc
I am trying to filter a large sheet that will need to be updated Daily or Weekly from a company-wide Excel Sheet. I have already uploaded a copy on a regular basis that changes when rows are added but need Smartsheet to filter the data using several criteria from different columns so that I don't need to do it manually…
-
Visual layout of Automation builder screen
I'm a visual person and I frequently find myself taking pause while trying to add on to automations that have multiple decision points due to the way the builder lays out the decision points. It slows me down and makes me second guess if I have placed the decision point in the correct location. The decision point is…
-
Automation to add links in a column in origin sheet from destination sheet.
Hi, I set up an automation to copy a row from someone's intake sheet when they assigned it to my team into my intake sheet. We did this so we didn't miss any of the metadata they are capturing. Can I set up an automation that copies a column that has "DAM Link(s)" from my intake sheet back into the original intake sheet…
-
Where are the auto-save settings
My sheets are no longer auto saving. When working on a building a sheet, if i hit the ESC button which I do as a habit sometimes, everything I have done since the last save disappears. It did not used to do that. It's incredibly frustrating as I'll be working on changes for 10-20 minutes then hit esc and everything I have…