-
In excel you can have multiple worksheets in one document. How does this work in smartsheet?
In excel you can set up multiple tabs or worksheets in one document. How can I best do this using smartsheet? Any tips? I have a excel sheet from finance using multiple worksheets and staff names, project codes and formulas for high level tracking of time against multiple strands of work. I would like them to use…
-
Manufacturing Scanning
We manufacture an industrial machine. As the system moves through the process at each station we would like to update the status of each machine with a qr code or a barcode, and trigger automation rules ie send emails or alert for issues if they come up. We want in the future to populate the smartsheet with info from…
-
Filter default settings
I use up to 5 sheets at any one time, each containing information relating to different customers. I frequently need to filter information on any particular sub-client via a text/number column. The default ‘Create New Filter’ uses “contains” for me to enter a unique name of the sub-client, and all rows applicable to that…
-
Dashboard Error
Hi guys, Wondering if anyone can help me out with a Dashboard error i am seeing? I have attached the screenshots relevant. * The error is presenting on a Dashboard which looks up to a Summary Worksheet, which in turn references the core detailed data. * The Chart Type i have selected by default is a Pie Chart (shouldn't…
-
Will Smartsheet ever support pivot tables or graphs of the data?
Wondering if Smartsheet will support pivot tables or graphs of the data? Would be ideal if this was a widget option in the dashboard views that could be shared with a group.
-
Excel Dashboard Templates
Is there any way to upload an Excel dashboard into Smartsheets so that it is converted to a Smartsheets dashboard? My boss is interested in using the Excel templates but annoyed that there aren't any templates available for Smartsheet dashboards. The beauty of the Smartsheet Dashboards is that external executives can…
-
produce a report.
Hello, ive been asked if we can produce a report with the percentage done column like the illustration shown below?
-
Identifying all links in a sheet
Another Smartsheet newbie here...I'm sorting through 25 (ish) sheets and there are multiple links between them. Trying to quickly identify all of the Links In and Links out for each sheet to quickly assess how everything ties together. Is there a quick way to pull this info vs. trolling through each sheet?
-
Count Formula
Is there a formula I could use to populate a number into a cell that is a counter of workdays since job has started, and it starts counting once a check box is checked off and stops counting when another check box is checked? this way we can keep an eye on our time frame of a job from start to finish
-
Can I partially mirror a sheet?
Hi, I hope someone can help me with this. What I'm trying to do is find a way to automatically share some information from a sheet into another. For instance, I want to have a sheet with all the relevant information for the company's projects, including financial information. Then have another sheet mirror most of it…
