-
Restricting Text/Number Columns to a Format
Hello all, I have dug around enough to be certain that there is no feature to restrict a column to a certain data type (i.e. restricting a text/number column to only be 6 numeric digits). This is something that would be extremely useful to have, especially with the amount of forms that I, along with my Smartsheet…
-
Automations Not Being Replicated Correctly By Control Center
For my project - I want Control Center to recreate sheets that have certain automations linked to it. These automations copy/move rows to sheets in the newly created project folders. However, when a new project folder is provisioned using Control Center, the workflow still writes the copied row to the original sheet in the…
-
Calculating time elapsed date and time
Hi all, I've read a few solutions on how to do this but just can't get my head around to apply it to my own sheet. I have an incident register that we are moving into smartsheet and one of the columns is duration of outage. In excel we have two columns; Incident start date + time and Incident end date + time (format…
-
OFFSET function equivalent?
I realize there is currently no smartsheet function equivalent to the OFFSET function in Excel. (But it would be REALLY nice if there was one!) Until that particular enhancement request is finally achieved...I need help finding a workaround. My situation: I have a sheet of data where the columns contain individual employee…
-
Graphs from Excel into Smartsheet
Is there a way to take a graph that was created in Excel and import it into a Smartsheet? I can do it via a dashboard but I would like to have it directly on the sheet with the data.
-
How can I set a dynamic filter on a report to auto change to today's date?
I have created a report to track upcoming go-lives to display on a dashboard, I currently have a filter that specifies an exact date, but is it possible to have a filter that pulls in data for a date 30 days before todays date or even today's date? For example, a condition that will say Original Go-Live is greater than…
-
Include Multiple Recipients on Single Email Alert
We are currently using a form to track internal requests. We are trying to get smartsheet to send an email to multiple recipients on a single email thread. Essentially using this form to generate an email thread which has all of the following recipients: the form submitter (dynamic) and all individuals within our solutions…
-
Import Outlook Calendar into Smartsheet
I was wondering if this is possible yet, or if there have been any updates? https://community.smartsheet.com/discussion/how-import-outlook-calendar-smartsheet Importing from Smartsheet into Outlook is nice, but I would love to have a 2-way possibility. I have a lot of projects going on all at once, trying to keep up with…
-
Will proper time formatting ever be implemented?
I am creating a form for a log keeping sheet, and want to include a time input, but would love to avoid people having to type it manually. Don't wanna see different entries of '02:00, 2:00p, 02:00PM, 2pm, 14:00, 14:00:00, etc' I see posts from 2015 with this same issue, and most responses are "smartsheet doesn't have this…
-
Need a option to copy only changes for last 7 days
There is a good option to review changes in last say x hours and day , I would like to know how to copy all rows where last changes happened for that filter to only copy and paste to someone asking for delta work for last say 7 days ?