-
Copy and keep cell value based on day of the week.
Hello All, Is there a formula that would take a value from cell "A", copy it to cell "B", and keep that copied value in cell "B" until a set number of days have passed? Backstory: I currently have a dashboard with graphs that illustrates a rolling 7-day, 30-day, 60-day, and 90-day account interactions. I would like to…
-
Time Formats - Number formats - Rethinking the UX and function
Having an entire dialog for text and number formats would make much more sense to me.. combine the currency, percentage, thousands and decimal places into it's own dialog box. We really NEED a way to save and modify the formatting of common things. So as to have them available and globally modifiable across workspaces. Use…
-
I am trying to figure out how to export to excel without the "Comments" worksheet for each.
When I export to excel one or more Smartsheets, the exported workbook contains a "Comments" worksheet for each Smartsheet. I prefer to not have these Comments worksheets within the workbook. Is there a way to export without them? Nancy
-
How do I avoid an export to Excel combining multiple cell values into one?
I have a sheet that contains cells that are populated from a multi-select drop-down. Many of those cells contain two or three separate values. When I export the sheet data to Excel, those multiple values get combined into a single value. For example: A cell in the sheet contains three category values: Content labeling,…
-
Missing columns on XML export of Gantt chart
I have several columns I need to export with my Gantt chart but only the standard Gantt columns seem to export. Every new column I added to the Gantt chart does not export. I even re-loaded the XML back into Smartsheet and the data is missing. Really need this to work to tie into a portfolio management tool the company is…
-
Different font in Gannt header exported to PDF
Anyone else seen this? Not sure if it has been like this since the start or if its a new thing... Is there a setting to correct this?
-
Integration with Power BI
Hi, I'm trying to link my data to Power BI in order to analyse it. Dos anyone know whether or not changing the formatting of data in Power BI would also change the format within Smartsheet? I assume not but thought best to check first? Cheers
-
Cell values export from one project to another
Hello, We are currently managing a construction project with smartsheet and have created a Gantt Diagram and a few Dashboard to monitor several KPIs. The dashboards are updated automatically with every changes in the master project and provide up-to-date information during meeting. I would like to add curves to the…
-
Import to smartsheet is unable to auto-assign tasks - any plans to address this?
Dear Smartsheet, The issue - import of a google/excel sheet containing an "Assigned To" column fails to assign to known smartsheet users any of the tasks listed in the file that was imported with matching user names/email addresses * The specific problem is that even though the name or email address values in the file…
-
Hyperlinks not exporting in excel
I am having an issue where my hyperlinks are not exporting to excel. This is something I have been using for months and just noticed it not working today. Is there a setting that has changed?
