-
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…
-
Soumitra Dutta-How do I get started with Smartsheet?
Hi Everyone, I'm Soumitra Dutta – Entrepreneur & Photographer Based in Oxford. I’m new to Smartsheet and want to get started using it effectively. Could you share your tips, recommended tutorials, or best practices for beginners? Any advice on how to set up my first sheet or manage projects would be really helpful. Regards…
-
How to Add Guests to a Workspace?
I have recently upgraded my subscription to a Business plan, which gives allowance for unlimited Guests. However the team that I already have added to the sheet are limited to Viewer access only and I am not seeing an option to change their designation. How do I make someone a guest?
-
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
-
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…