-
Exported File Hangs Excel
I am working on a complex set of sheets and I need to compare the data in two different versions. I have exported each of the two sheets multiple times and, as of this morning, any Excel version of an export hangs Excel when I try to open it. I realize this may be an Excel-only issue, but Excel is otherwise working without…
-
Is smartsheets payment system working?
I've tried repeatedly to add a new user to our account. Over the past three days I've attempted this a perhaps a dozen times by clicking through from the automatic email my colleague has sent via smartsheets requesting a new user licence. I have no success with it either this way or going directly through the 'change your…
-
Decimal Places in a cell
We have a Smartsheet that we use for tracking payments made to a different country and therefore in a different currency. We have an exchange rate column and for the company we use to make the payment, the exchange rate is given with 6 decimal places. However, the Smartsheet only allows 5 decimal places to show. Is there a…
-
Issues when I print my dashboard
I have the following issues when I print my dashboard: The colour scheme of the widget headings is lost when I print and they revert to black text on white background. The dashboard doesn't fit on the page width when I print even though I select scaled to fit page on the printer settings. How can I remove the header and…
-
Dropdown in Report
Hi Everyone, I have a sheet with a dropdown column. I have created a report and I want the team to update the data from the report instead of the sheet as the sheet has over 500 rows and data has to be updated in some specific rows. But the dropdown option is not available in report. Am I missing something or is it not…
-
Internal Employee Merch Shop?
Hello, I have been asked to create an Employee Merch Shop of sorts. The ask is to create an on going place where employees can order (they don't have to pay) for company attire. There is a variety of choices including, company t-shirts, hoodies, jackets, hats, etc. I then would place the order from our apparel vendor. We…
-
Convert form response in to standalone project?
Hi, I created a Smartsheet form to intake requests for support from my team. I'm not aware of an easy way to then create a project based off of the form response without having the Control Center add-on. Ideally I would like to set up a system where I can view the incoming requests then approve/reject/send back for more…
-
Report Viewer on Dashboard optional Gantt view
Can someone advise how to deselect the Gantt view option for a report on a dashboard? I created a report with Deliverables and when i add as widget on a Dashboard, it automatically displays the Gantt view. I would like to opt out, as shows as optional, but don't see anyplace to change. Thanks!
-
Updating a field within workflow
I have two questions: Is there any way a field can be updated based on the action taken within a workflow? For example, I have set up an Approval workflow with Accept/Reject options. When the Approver take action, is it possible to capture the Approver name/email in another field within the same SmartSheet? Is there a way…
-
new summary fields not able to be added
I added a new summary field to a sheet so I could include it on a dashboard, but when I go to add a metric widget to the existing dashboard the new summary field does not appear. I have tried pointing to a different sheet, logging off smartsheet, and even verifying that I added the summary field. Is there a refresh that I…
