-
Calculate the time between two dates by days, hours and minutes
Hi, I am trying to implement the following formula from my excel spreadsheet into my smartsheet: =INT(O2-Q2)&" Days "&HOUR(MOD(O2-Q2,1))&" Hour "&MINUTE(MOD(O2-Q2,1))&" Minutes" Basically, i need to calculate the time between two columns (date received) and (date documents issued) in days, hours and minutes. Cell 'O2'…
-
Export Smartsheet attachments to OneDrive
Hi! I'm using Smartsheet to gather information through forms. People fill in a form, they add a picture in the submission, and all this gets saved in a sheet. Eventually, I receive rows filled with information in Smartsheet and for each row there is a picture attached. I need these pictures not only within Smartsheet, but…
-
Export or Print Multiple Reports Through Action Drop Down
Anyone know of a way to batch export or print reports? Planning on running upwards of 50 reports and I want to be able to print through the actions drop down to capture all of them at once rather than opening individually and clicking print one by one.
-
Export a Published Report
Hello - I have published reports to a dashboard that my clients can go and check. However, I've noticed that, if you're looking at a published, read-only report, you can't export it into any useful format, such as excel. Is there something i'm missing? Andy
-
How to reduce Excel spreadsheet to 400 max. columns
How to reduce Excel spreadsheet to 400 max. columns which is the limit for importing the sheet into Smartsheet?
-
Automatic Deletion
I am looking for a way to set up an automation for deleting rows in a sheet. My firm is unwilling to go through security testing right now and is wary of putting sensitive data on Smartsheet, but is wanting to use a form to collect the data. They propose that a notification is received when someone fills out a form and the…
-
Activity Log CSV Export - Bug
I just tried to export an activity log csv and I was sent an email to download a .zip (theoretically) with a csv inside. However, when I got the .zip there was no csv inside and when I tried to unzip I got an error message that said the zip file is corrupt. Anyone experience this?
-
Importing Excel Data into a template
I have created a template with all of the appropriate columns, workflows and filters that I need. I have a 4900 row Excel spreadsheet with my data. I would like to import the Excel spreadsheet into my template. I can copy and paste, but since the limit is 500 rows at a time, it takes time. I cannot seem to find a way to…
-
Converting project links from report to hyperlink in Power BI
I have a report that I am using to feed into a Power BI file. There's a column in the report for a link to individual project sheets, but this column shows up at text only in Power BI (For example, a clickable hyperlink to "Sheet A" in Smartsheet shows up as "Sheet A" as text only in Power BI). Is there a way to get the…
-
Jira Connector only allowing one project to one sheet
Hi, We have recently implemented the Jira connector for Smartsheet and this is working well in each sheet where we have a one to one relationship with Jira Projects. We have a single sheet which is collating all enhancement requests (using a web form as a front end) which will place enhancements into the relevant Project…
