-
Using INDEX/MATCH for a Master Sheet
Hi all, One way we use Smartsheet is to record real-time data that is then stored and referenced. I work at an aquarium so, for example, we will take daily measurements across multiple systems for things like temperature, salinity, pH, and on and on. The same parameters are tracked for all of our systems, but the thing is,…
-
Restoring from Sheet Snapshot when auto-generated numbers are involved
I recently inadvertently deleted a large amount of data from a sheet that has an auto-generated number column. While I know how to restore from a backup, I have no idea how to restore the originally assigned auto-generated numbers without completely messing up the sheet. Has anyone come up with a creative solution to…
-
Creating a summary for a workspace
I have a workspace that has a revolving set of sheets. Some of the sheets are active for the time being but are not active now. There are several cells that I would like to have on the summary , like the client name, the status of the sheet, the date expected to go live, health of the sheet. What would be the best tool to…
-
Need to retrieve the complete driver payroll sheet
I am unable to retrieve the complete driver list and would like assistance in recovering last Friday’s data
-
Enhancement Request: Allow changes to Column Type when Conditional Formatting is set
If a column is associated with any Conditional Formatting, the column type can not be changed. This is true even if the Conditional Formatting Rule is disabled. This is true even when changing Column Type from 'like' types, for example Text/Number to Dropdown List. This is an inconvenience, minor at best, severe at worst…
-
Doing a mass update of sheet reference names
I have been waiting for find/replace within formulas, but wondering if there is a different way to solve my problem. I have raw data in quarterly sheets that feed an annual sheet where the data is broken out monthly for the whole year. Every year I create a new annual sheet and have to update the formulas with the…
-
Project Dashboard Margins
I have a project dashboard that i like to print for meetings. When I print to a standard 8.5x11 the report does not fill up the entire page. Allow users to edit the margins of the dashboard grid. Say to 8.5 x 11 that way when they hit print it automatically fills the page
-
ERROR MESSAGE CAN NOT OPEN PROJECTS FOR 7 DAYS
I have a current paid account but smartsheets will not allow me to open my projects. for over a week, I submitted a support ticket but no one has contacted me to resolve this issue. This has caused a major backlash.
-
Resetting MFA for an Admin account?
Hello - I support an organization that is using SmartSheet. The lone administrator misplaced or deleted the MFA token, so we're locked out of admin features. We need assistance.
-
Access rights for the Smartsheet connected to dashboard
Hi, There should be an option for an Admin of a dashboard to be able to request access to the smartsheet/metric sheet that dashboard is pulling the data from. So, for example, my colleague X uses smartsheet 1 to pull data into Dashboard 1. Now, I am working on the dashboard 1 as Admin, with no access to smartsheet 1. But…