-
Formula working for one data value but not another
Hi Community, I have a sheet that contains, among others, columns titled "Priority" and "Contract ID". Multiple rows can have the same Contract ID and the same Priority. Priority values are 1-2-3 and restricted to dropdown list values only. To collect the number of unique Contract IDs that are Priority "1", I have this…
-
View Only account
Hi, I have paid my monthly fee and annual few but i still get a view only error
-
Lost all tasks in Gantt view
Today Mar-18, I've lost all my tasks in gantt view, but they are still visible in card view or grid view. Yesterday i've shared the sheet with the team with view only access. Did anyone have similar issues? and how to resolve this?
-
Automation of Weekly Updates
Hi all, I have a Smartsheet that I use to track multiple document requests for multiple clients. I need to provide updates to client contacts (sometimes more than one, and they may have more than one client connected, but the updates should be by client) that are connected to each client on a weekly basis. I'd love to…
-
Cannot turn off "Send as Attachment" in a sheet
My manager set up a weekly smartsheets attachment of a sheet to be emailed to them every week. She now wants to turn this off but when her and I go into the Send as Attachment section of the page it only shows that two were sent instead of weekly for the last year or two and there is no way to turn anything off. How do I…
-
COUNTIFS formula across sheets
Hi all I've been using Sheet Summary's to calculate some data which seems to work quite well. For instance this is an example of a Summary that is working fine. (Its an ISO27001 audit tracker sheet) =COUNTIFS(Finding:Finding, "Opportunity for Improvement", Status:Status, <>"COMPLETE", [Agreed closure date]:[Agreed closure…
-
Mistakenly Cancelled my Business Plan
Hello good people. I cancelled my Business plan by mistake, before transferring ownership to other account. Now i have enrolled and paid again i still cant edit my workspace and sheet as they are on view only. Please help me on the way forward.
-
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…
-
New Portfolio feature Question
We are using the new EAP feature called Portfolio to manage projects in Smartsheet. I want to try out some of the features in there such as report building across the entire portfolio, but I don't know where to access that feature. Specifically, I'm reading through the PDF documentation and on page 7 is shows that you can…
-
Click-Through Capabilities for Smartsheet Calendar
When publishing a calendar from the Smartsheet Calendar widget to a dashboard, users can still slick through to a calendar list via the header in the calendar. There should be a way to "lock" the calendar view to a published dashboard that prevents users from clicking-through to other areas. This "locked" calendar should…