-
Manage seat types more effectively at scale!
To provide you with greater control over your Smartsheet subscription, we have implemented the following updates: Modified Provisional Member counts: Now, Provisional Members are considered anyone who’s commented, edited, or created in the last 90 days versus just being shared to assets with Commenter or Editor access.…
-
Plan & BIling
Hi, Currently i'm on business plan, and i have 2 paid users, I've converted 3 more users into paid users from provisional membership, please clarify the below points it's very confusing. 1. in attachment 1 it says 0 of 2 members, 2. in attachment no.2 it shows Billable seats 8 and purchased member seats 5, additional seats…
-
Bulk Removal of Sheets from Reports
When in reports looking at the sheets button next to the columns button, it would be nice to have a delete all sheets button and a way to maximize the scrolling to see more than 4 sheets total at once as it's extremely difficult to search for individual sheets.
-
Form Submission Error Message
Hi Everyone, I have a form that I created which has been working just fine until I had a user notify me that they were getting this error message: I had them refresh and try again but he kept receiving this message. I then also submitted a Test form and that worked fine (although took a while to refresh on the sheet). Does…
-
[UPDATED] Community Reward Program 🏆
Hello Smartsheet Community, We value the way you support and encourage one another and want to recognize your efforts with our Community Reward Program. As you engage with the Community you'll level up and unlock rewards including swag, and access to previews and beta features. Curious? Read on to learn more about our…
-
Need support using wildcard & sumif function
Hello, I have a sheet that's I'm trying to use the sumif function in, but I'm trying to base the criteria on a wildcard. For reference this is a sample sheet I made, and the wild card formula works fine in excel. Essentially, I want to SUM the values in the "RoleValue" column for a specific condition in the Quarter…
-
Advise on Workgroups and access for Groups
I have Workspaces that have sheets containing sensitive information. The Workspaces have Individual access to a few people. With in the Workspace, I created Dashboards, with Dynamic Views. Each is set with specific Groups to access specific information. The users in the groups can not see or access the Dashboards, unless I…
-
Dirty save - #BLOCKED/Invalid Value issue when using integration until manually save the sheet
Hello everyone, We’re facing a critical issue in one of our Reports. We use integration and it adds values to the sheets. The corrected values don't seem to auto-save. Formulas in sheets first show #BLOCKED/Invalid Value, then if we refresh the sheet - it updates to the correct numbers. The save button is active even…
-
How to prevent or recover deletion of rows
Is it possible to prevent the deletion of rows in a sheet? Specifically, in cases where a user legitimately requires editor permission to the underlying sheet and where the row cannot be locked (as continued editting of the row is required.) If not, what are some strategies for recovering a row that has been inadvertently…
-
Counting specific names in a table from a specific drop down menu
Hello everyone, I am trying to create a cell that calculates the number of times a certain name shows up whenever a criteria is chosen from a dropdown menu. Currently, I have Column E with a dropdown menu of names (uses data from Column L). Column F will use that cell as a reference to populate a cell using VLOOKUP…