-
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)…
-
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?
-
It would be awesome if you didn't force me to refresh in the middle of editing form logic!
Form Logic can be very tricky, and when you send me a popup that I can't X out of to save first, all I can do is click refresh, that ruined everything I was working on! What a waste of time!😡
-
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…
-
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…
-
Combine Contacts from multiple columns into a single cell
Allowing contact columns to be combined into a multi-select contact column would make team management and index sheets much more useful. If Columns 2 through 10 on my sheet are all contact columns, a formula like =Contact2@row + Contact3@row + Contact6@row should produce a multicontact cell, not a text cell. That would…
-
Inquiry on Smartsheet API update Requirements by this June 3rd.
As per the mail sent by Smartsheet team (June 3rd Deprecation), we verified that below API end points were not the part of the provided deprecated APIs. But cross verifying again, please help us to verify the impact of the below end points. a.Get Sheet – GET /sheets/{sheetId} b.Rename Sheet- PUT /sheets/{sheetId} c.Copy…
-
Automation Infinite Loop Error
Hello, I created an automation so that my Status column automatically changes when my % Complete column changes. Basically, the automations are the following: If % Complete = 0% then Status = Not Started If % Complete > 1% and <99% then Status = In Progress If % Complete = 100% then Status = Complete My automation runs…
-
Licensed users not showing up on User Roles and Reports
We pay for 113 licenses. 119 licenses are assigned, so 6 seats will be added this week to "true up". However only 103 users show up in my User Roles and Reports list that I can manage. The missing users would include 10 current members and 6 additional "true up" users. No users are in a pending state. There are no open…