-
Is there a way to run a report on a user's activity?
I know I can run their smartsheet access report but that doesn't give me the information I need. I think the best way to explain what I am looking for is to give an example. I am trying to create dashboards for some of the executives so they have their most used smartsheets all in one place. The user access report says…
-
Multiple User Views on Dynamic View
I am creating a dashboard that contains Dynamic View. Is there any way to create multiple views for different contact lists? I know that dynamic view can be based off of a contact list or group, but is it possible to have a "view all" for someone higher level? So a manager can see the entire list while a lower level can…
-
How to create metric from timestamp in sheet
I am trying to create a metric in my dashboard that shows the average time of day that each contact submitted their request. The specific date is not relevant. Please help Thanks!
-
Problem with vlookup calculations
I am having a new problem with an existing Smartsheet that has worked fine until now. Existing workflows have stopped working. The problem does not appear to be workflow, but something else going on. We have a workflow that triggers off of a calculated field that is based on data in another Smartsheet. Users enter data…
-
Backups/Excel export
Hi all, Would it be possible to backup/export a spreadsheet on a scheduled basis more often than daily? One of the Departments on my company asked if it would be possible to do it hourly or even every 10min, but the smallest period i can find is daily...
-
Custom Development Possible?
Is it possible to have a developer build a custom button in smartsheets that can for example pull data from it ..into a document.. Is smartsheets open to being developed on? I have the business package.
-
How to make % frequency chart in dashboard (reasons for QC failure)
Hi, I am trying to make a chart in my dashboard that displays the reasons for QC failure as a percentage of overall frequency. The input is from a sheet with a column as shown below. You can select the mode of failure from a dropdown menu, and can select multiple items if there are multiple modes of failure. "In Dashboard"…
-
Collect and display nearest dates
I have a job tracker designed to track the art components of our jobs. We would like to have a column display the next nearest due date for that row. My trouble is we may have 1-10 due dates on a given row and there are non-date columns between each of the due date columns. I'm fairly sure I need to use a MIN(COLLECT( type…
-
Can I auto-tab to a new field in forms when scanning barcodes
I am attempting to use barcode 128 with a control code to tab into the next field. When I scan the barcodes I am being pushed out into the address bar, instead of the next field. I've tried the Codes for Horizontal Tab, Vertical Tab, Line Feed and Form Feed. Is there a special code for smartsheet? I'm not super savvy, but…
-
Inventory Status: Reordered (How do I do it?)
Hello, I am developing an inventory reorder system and I need the status of the line item to show "Reordered" when the check box is checked under "Order Status" I recognize that there are multiple true statements within my formula so how can I show "Reordered" while the stock quantity is below the ROP? I have been trying…
