-
Import data directly into existing sheets in table view
February 16, 2026 We've all been there — you have a spreadsheet full of data sitting on your desktop, and you need it in Smartsheet. Until now, importing a file meant reverting back to grid view. Now you can stay right in table view and import your data without ever leaving the view you're working in. Now you can import…
-
How to make a Static Sheet Form for Multiple Cells?
Basically I have a questionnaire template for projects that I created that I need as a sheet to allow people to enter scoring rubrics and comments into a master sheet, but the projects need their own static sheet in each cell of the master sheet. Is there an easy way of doing this without having to create a million copies…
-
Issue with COUNTIFS Formula Referencing Auto Number Column in Smartsheet
I am currently working on implementing duplicate detection logic in our Baseline sheets within Smartsheet. The requirement is to identify duplicate Project Codes and assign a sequential baseline order (1st, 2nd, 3rd, etc.) based on the order in which rows are added. While attempting to implement the logic using a COUNTIFS…
-
Reports - How do I add a specific cell from every sheet
I have a workspace that has several sheets and I want to create a Report that shows me the cell Column5 row 6 from each of those sheet, and if the content of that cell is equal to a specific content, then i want that sheet to be on the report. After that I want to add Column6 row 3 to the report from every sheet that met…
-
Does SmartSheet have an equivalent to Excel's "Name Manager" and "LAMBDA"?
I need a way to label a specific set of data or create a custom function that can be used in cross-worksheet formulas. Related to another query of mine, I need to take a list, give it a specific name, and reference it without having to navigate to the source sheet every time it's needed. For example, let's say I have a…
-
How do you create a dynamic list of unique values from multiple sheets?
I am trying to create a "level of effort" calculation where we compare the count of bidded, lost, and awarded projects against a specific criteria, which is often a dropdown column in the source sheet. I have tried using JOIN, COLLECT, and INDEX from at least a dozen posts in the Community but nothing has worked to date.…
-
Copy Single Cell to Cross reference sheet
We’re using a portfolio management tracker. When a dropdown field in the Regulatory column is set to anything other than “N/A,” I want to automatically copy just the Initiative Name, Regulatory Dropdown, and Owner columns to a different sheet in the same workspace. I do not want to copy all columns—only these specific…
-
Contact Columns ≠ Consistent Data
The Core Issue with Contact Columns Smartsheet Contact columns are fundamentally not reliable because they don’t represent people consistently. The same person can appear as a name in one place and an email address in another, depending on user status, permissions, ownership, or whether the data is viewed in a sheet,…
-
Help with functions for attendance tracker
I'm attempting to create an attendance tracker that will add up the total points for a given representative based on the type of 'event' such as No Call No Show, Late Arrival etc. I have a sheet set up that automatically enters the number of points based on the event, calculates any adjusted points and shows points…
-
Unable to Print
I had two nurses call and tell me they are no longer allowed to print their shift report from SmartSheet. Trying to print from the browser leads to a blank print preview page and the below message; there is no print option available on the SmartSheet toolbar.
-
Mysterious Date Changes... Dependencies and edays?
Hello, I've had a few users reach out to me today about seeing changes to their project plans, but no one went in to change dates. The activity log was clear of anyone specifically doing anything to affect the start and end dates. The recent user, after investigating her plan, had a predecessor (our dependency column) that…
-
External User Access
Hi! We are reviewing the the 'Seat Types & True Ups' menu in our Admin setting in Smartsheet. When filtering under the external users (not in our domain and people who never had licenses) there are numerous emails listed and we have zero idea what specific items they could have access to. We've run all the reports offered…
-
User Subscription Model: Non Admin access to Users Seat Type
Hello, I am a System Admin and want to provide assistance for Workspace Admins at my company with regards to User Seat Types. From this help article: https://help.smartsheet.com/articles/520104-share-sheets-reports it mentions this: "Ensure that collaborators you’re sharing your sheet or report with have the right account…
-
Allow Redlining & Highlighting within cells
Currently, you can do redlines etc but it always effects the entire field. Which is really quite annoying as in project work you sometimes wish to strip out part of a requirement while keeping it tracked. If we could allow more specific editing within a cell that would be ideal. You can work around this. But it will hurt…
-
Formula not Calculating the Correct Number
Hello, I have a formula that counts notifications that are tracked on another smartsheet each month. The formula is: =COUNTIFS({Date of Notification}, >=[Start Date]@row , {Date of Notification}, <=[End Date]@row , {Impacted Department}, <>"XX") The results from this formula are no longer calculating correctly. For…
-
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
-
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…
-
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…
-
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
-
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…
-
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.