-
PDF reports with totals
Is there any way to show the totals on a report when sent in PDF form? Anyone found a solution or workaround?
-
Why can't I update a row with a Form?
I'd like to allow users to update information in a row via a Form. I like the user interface of the Forms and would prefer to keep users away from the spreadsheet. I know about locking information in the spreadsheet and that is not what I want to do. Our spreadsheet has a large number of columns and I want the user…
-
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.
-
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…
