-
Global Referance point
I and I think alot of others really need this, We need to be able to have a global reference point so that we can reference across multiple sheets that have that same column . at the moment we can only refence one sheet at a time per formula example: =INDEX({MACH MAT}, MATCH([Row ID]@row, {MACHROWID}, 0)) If i want to find…
-
How Can I Combine Multiple Percentages Into One Cumulative Percentage?
I'm working on a project that has multiple components connected to the overall goal. To better know where we're at, I've created a done category to track progress in a percentage based on when a new box is checked. To accomplish this, I used the following formula: =ROUND(COUNTIF(Done3:Done8, 1) / (COUNTIFS(Done3:Done8, 0)…
-
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…