-
Number and Fraction Format
We currently use a considerable number of sheets that need numbers to read as fractions. (Construction/Exhibit Industry for dimensions) Unfortunately, if you type out a number as a fraction it cannot be used in formula. Excel can translate easily between decimal and fractional display with cell formatting. Will there be a…
-
How do I find a smartsheet expert for hire to help build out our workspace?
I am building out a new workspace for some large marketing intergration projects. I am way over my head with smartsheets, but I have used it to complete amazing M&A sheets. I want to start intetegrating smartsheets into the operating side instead of just the due diligience side of the business.
-
automatically export and then delete rows
We use SmartSheets to collect a large amount of data using a form. We reach the Smartsheet size limits almost weekly. Currently we log in each week, export the data to excel, and then delete rows based on a date criterion. I have looked at Zapier. It looks like I can have it email me the data in excel but the free version…
-
Smartsheet Dashboard Embed Power BI
The new dashboard feature for Smartsheet says we can embed power BI reports by publishing to web, but doing that in Power BI makes your report public to everyone. How can I embed while still mainting privacy as these reports have company information? There is a Power BI option that allows you to embed directly to…
-
Jira Connector with Story Points
We have been successful, through trial and error, getting Jira connected to Smartsheets in a bi-directional fashion. One key piece of functionality that would be helpful is utilizing the story points from our Jira system. I noticed in the workflow builder we don't see that as an option to migrate our Jira Story points into…
-
Import Excel Workbook
Good morning, Is there a way to import a whole excel workbook and not just 1 tab?
-
Preserving drop down list on import
Is it possible to preserve the dropdown choices when importing an excel document?
-
PDF Exports
Hi Everyone, Is there a way to export a row to PDF but select the columns that you want to include? At present, I'm printing the row and saving to PDF; however, I can only select to either include or not include comments and hidden columns. Clicking File and export to PDF does not give me the option to select columns and…
-
Hyperlink function
Hello all, Is there a way to do the following: =if value in Column A, return hyperlink to Column B This is not a website hyperlink, this is a hyperlink to a smartsheet item. I have tried pulling hyperlinks through VLOOKUPs, nested if statements in the same sheet, etc. Manually clicking through and adding hyperlinks 1 by 1…
-
Feature request - Borders
Just trying to pretty things up, and see that borders are not something you can modify in SS. Here's a request to add that some day. (oh, and please make it work with Excel import/export)
