-
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.
-
Why can't Smartsheet work in an Ipad Browser?
I understand there is an IOS app but it does not come close to the computer browser based environment, it doesn't perform as well, doesn't have matching capability, heck even the user interface is different. I do not care for the app but I love Smartsheet in a computer browser. I am baffled as to why Smartsheet does not…
-
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 ?
-
Time Tracking - Hours and Minutes
I was working on a way to track some task hours and minutes... came up with this: One of the problems I ran into is that if you put "00" (double-ought) or any minute with a preceding zero, it would error. You can see the work-around I made, not the most elegant, I admit.. If Smartsheet could ignore preceding zeros, it…