-
Important update for Pro plan users: One-time redirect to table view on July 29, 2026.
Dear Smartsheet Community, Over the past year, we've invested significantly in evolving table view into our next-generation sheet experience. Table view delivers all the core capabilities of grid view while offering significant improvements in performance, collaboration, and new functionality. Thank you for your ongoing…
-
Sheet webhooks now support custom headers
June 29, 2026 Great news for developers building integrations with webhooks: sheet webhooks now support custom HTTP headers. Previously, authenticating webhook payloads meant adding logic on the receiving end to validate callback URL tokens, IP allowlists, or post-receipt signatures. That added friction to the development…
-
Best practice for cross-team project dependencies and consolidating reporting?
Hi everyone, I am looking for advice on the best way to architect a cross-team project tracking system. My current setup: * I have multiple teams, each maintaining their own individual project sheet. * Each sheet contains a list of projects specific to that team. The Goal: * Cross-team Dependencies: I want to add a…
-
COUNTIFS in Sheet Summary utilizing a Contact Card column
I am trying to create a sheet summary, where the field is a formula that relies on a contact card within a column. However, it keeps returning a result of "#NO MATCH". The columns involved are, 1:) Priority (symbol column) for Up, Unchanged, and Down, and 2:) Contact Card column. I am trying to get a sheet summary formula…
-
Sheet Summary - Column Totals - How to Combine in a Report
I have #'s that pull from each project into each sheet's - sheet summary. Those then get pulled into a sheet summary report. They are currently grouped by what channel they are in. Each column gives a total sum. I was asked to see if we can combine the total sum into one number, so it shows how many total SKU's are being…
-
Old File Name showing up after making a copy of a Sheet
I have been copying a sheet and modifying it each year. The automated reminder messages I get from the sheet continue to display the original file name, not the current one. How can I fix this? ex: The old sheet was 'Calendar Planning Master 23-24'. The messages have shown up with this title in 24-25, 25-26 and now the…
-
Using SMALL + COLLECT to rank items by due date — duplicates showing the same row
I'm building a "Top 4 Critical/High Priority" tracker on a dashboard sheet that pulls overdue items from a RAID Log using INDEX/MATCH/SMALL/COLLECT. Here's my current formula: =IFERROR(INDEX({Task Title Ref}, MATCH(SMALL(COLLECT({Due Date ref}, {Due Date ref}, <=TODAY(), {Priority Ref}, OR(@cell = "2-High", @cell =…
-
Report Inquiry
Does anyone know how I would organize a report sheet by date instead of by project number ? I wanted it to be in date order instead, oldest - newest. Any help is greatly appreciated
-
Unable to View Workspaces and Sheets While Creating Cross-Sheet References
I am experiencing an issue while creating a cross-sheet reference in Smartsheet. When I open the Reference Another Sheet window: * The list of available workspaces and sheets does not load. * The Recently Viewed Sheets section is also empty and does not display any recently accessed sheets. * As a result, I am unable to…
-
Locked Rows Permit Editing of Dropdown List Columns by Non-Admin Editors
I have reproduced the following behavior in a validated Smartsheet application. * User permission: Editor (not Admin) * Row status: Locked (confirmed via row menu displaying "Unlock Row") * Text, Date, Contact List, and Checkbox columns cannot be modified. * Dropdown List columns remain editable. * Selecting a new dropdown…
-
I NEED HELP PLEASE_ EVERYTHING IS GONE
I logged in this morning and it said I needed to upgrade my business account to keep using my sheets. I am NOT a business member, I am a pro member paid in full for the year. ALL of my sheets, reports, dashboards, EVERYTHING IS GONE. I use this to run my business (sole member) and have spent four months building my sheets.…
-
Developer API and getting started
Hi, We are a developer and building a custom web platform for one of our client who is using smartsheet. Our platform needs to get data from smartsheet and need to show the data in our custom UI. Could anyone recommend the APIs we should be using for this?
-
How to add file upload to Update Request worklow
Hi everyone! I was wondering if anyone knows a way to attach a file upload space to an update request. I have already set up a workflow to send out a update request at the appropriate time but I cannot find a way to add an upload space. I know that I can add attachment when I manually send update requests, but I was…
-
Our Smartsheet was shuffled.
I need help. Our Smartsheet was shuffled. We dont have access to the logs. is there a way to unshuffle it and put everything back together?
-
I am the account owner but it says that I only have viewer access
Please assist me, I am having trouble with my smartsheet, I am on a paid pro plan, with 5 paid members, but neither I or my members can access or edit sheets. When I try to share the sheet, it says that I only have viewer access. My team members cant access the sheets at all. I renewed my subscription recently and it seems…
-
Safe Sharing impacting Automation Notification
I know I have been told the Safe Sharing logic is working as designed, however I would like to challenge that. Simply put: To me, there is a difference between Safe Sharing vs. merely sending an Automation Notification following a Form submission. We are NOT sharing anything — we are merely sending an Email, confirming…
-
Automation Action: Auto-collapse parent rows based on status change
Hello everyone, I'd like to suggest a new automation action: "Collapse Row" (reduce/fold a parent row). Use Case: When managing projects with parent/child row hierarchies, once a parent task is marked as "Complete" (or any defined status), all its child rows become irrelevant for day-to-day tracking. Currently, there is no…
-
Exclude canceled tasks from the automatic calculation of the parent's % complete
Hello everyone, I'm working on a project sheet (with dependencies enabled and the Gantt view) and I'm looking for a way to exclude canceled tasks from the automatic calculation of the % complete on parent rows. My requirement : When a child task changes to “Canceled” status, I want it to no longer be included in the…
-
Sheet Summary Average for last 180 days
I am trying to make a sheet summary that will give me the average of column "# of Days Open" if column "Date Entered" is equal to the last 180 days.
-
Dynamic View - unable to create a DV even being an owner of the sheet and having the DV button enabled
Hi I have an enterprise plan and I'm the owner of the sheet I'm working on inside SS. However, when I try clicking the Dynamic View option inside the sheet, it takes me to another tab where I can create new DV's but when I hit "Create" after selecting the right sheet, it doesn't work. It loads briefly but nothing happens.…