-
IF formula to return date based on drop down selection
I have a formula that is working correctly returning a date based on a drop down selection. Now I need to incorporate business days into that return date instead of total day. I have 3 columns i'm working with, Priority, Requested date and Request due. The user will enter the date the request is received and select the…
-
Improved PDF Exporting of Dashboards
I have created a dashboard that I would like to export to PDF to share to people that do not necessarily have Smartsheet and more importantly don't want to open links/attachments to get "quick glance" data. When I print as PDF I loose a lot of formatting and can't centre the data across the page. without customising…
-
Select which columns to copy or move from one sheet to another
As part of the automation it is possible to copy or move a row from a source sheet to a destinatio0n sheet. At this point all columns are copied/moved, and if a column do not exist it will be created in the source sheet. The request for this improvement, is to allow the admin or owner of a sheet to select which columns…
-
Filter for rows that are due to day and in the past
I want to be able to filter a sheet to show the rows that are due to today and any that are overdue, i.e. in the past. i have a column called due date and another called status which is either started or complete. the filter i have on is 'status = started' and 'due date = today' . however i would want to filter on 'due…
-
How can I get the column to accurately track hours elapsed?
Hello! Trying to have Total Time calculate total hours elapsed from Start Time to End Time. I created "helper" columns based on another question's answer, but it didn't help. We use 24-hour clock here and I need the column formula to consider that some values will start before midnight and end after midnight and will…
-
Join us for a Accreditation Survey Prep & Survey Tools Community Call - Dec. 5 @1:30pm EST
Missing the excitement from Smartsheet Engage? We are too! Let’s keep the momentum going! Join us on December 5, 2024, from 1:30–3:00 PM EST / 10:30–12:00 PM PST for an exclusive Community Call featuring Regina Shelnutt, Accreditation Manager at Tanner Health. Regina will showcase her innovative Smartsheet solution for…
-
Send email notifications to Data Mesh config owners when a config is broken
I'm relatively new to Data Mesh, so feel free to point me in the right direction - but apparently one of my configurations was broken and I did not receive any notification that it was not working properly. I was notified by an end user that it was broken which caused me to investigate. Especially for paying a premium for…
-
Enhancement to update Data Shuttle to recognize/preserve leading zeros in front of numbers
Use case: Managing hundreds of cloud accounts that have a fixed length ID and a randomly assigned number. Some account IDs have 1-3 leading zeros, some have none, as long as the overall length is 12 digits. Issue: When using Data Shuttle to import updated lists of accounts, existing accounts with leading zeros, are deleted…
-
Why am I not seeing the form submissions I receive in my Smartsheet?
I have submitted 3 forms but can't see the submissions in my Smartsheet.
-
Number column with leading zeroes
I need a way to keep leading zeroes for numbers in a column, but also keep them in number format for sorting purposes. These are test codes so leading zeroes are necessary but Smartsheet kept converting them into text.
