-
Sorting Activity log by Client Name / Internal Organization
When I access the activity log - it shows everyone who has accessed Smart Sheet in a specific Timeframe. Is there a way to filter to only show people who have accessed it that are in my Internal Organization? I tried using the collaborator field but it only lets me put in my email. When I put in other team members email…
-
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)…
-
1 master report linked to multiple other reports
Is there a way to have a master report that is pulling in the data from all of the necessary sheets and then several minor reports off this one where certain rows can be shown in certain sheets? The reason for this is because as projects get created in the workspace the admin then has to go into 5 reports and link the new…
-
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…