-
Bulk/easier removal of users from shared sheets
It is painful when you need to remove users from shared sheets, VERY labor intensive. Especially when you have a years of sheets where they have not been removed. It is great to see all of the sheets people have access too via the workspace access report, if that could be an interactive instead where we could select and…
-
Approval Workflow - Triggers for Comments
Hi, I have currently implemented a workflow that records Approval responses up to 3 times for the same request if the approver needs more information. This is a clunky implementation and I am looking for ways to improve it by simply using "comments". The outcome I'd like to see is: Employee completes form and triggers the…
-
Dynamic View- Auto Refresh
Currently Dynamic View doesn't have any auto-refresh settings, When working with Cross-Functional teams, and you need to see latest data. This basic feature/capability unavailability is a big hinder in using Smartsheet Dynamic View. Please consider incorporating it. Thanks,
-
Index-Match-Collect failure
Hello - I have a formula that I use to find the next upcoming task showing as "Not Started" and assigned to "Joe Smith." It has worked seamlessly for months and now all of a sudden is returning an incorrect value and I am totally stumped as to why. Here is the formula: =INDEX([Task Name]:[Task Name],…
-
Formula to calculate task completion by owner by referencing parent rows
Hello all, I am looking for some help with a formula. I'm super close to getting it but can't figure out the last piece. Goal: I have a sheet tracking task completion and want to calculate, month by month, the percentage of tasks completed for each person. Setup: Level 1 rows = person’s name (owner of tasks) Level 2 rows =…
-
Option to Toggle off Admins Receiving Access Request Notifications
With the new update rolled out last month, all sheet/workspace Admins now receive access request notifications instead of just the Owner. This is causing major headaches for the large corporation I work for. We have thousands of users and many do need Admin permissions to perform their tasks in workspaces. However, they do…
-
Dynamic View - Creating view for "Current User" based on multiple columns.
We currently have a data sheet where monthly we ask users to populate a high level overview blurb for leadership. There are multiple Contact List columns populated with the individuals who may enter the data. At the moment, I send out a report that has two groups of filter conditions: Project Status is one of "Active" AND…
-
Locking down an individual column to only allow one user to edit the column
We would like to lock down an individual column to only allow one user to edit the column. Unfortunately, we have several people updating the smartsheet and we would like to lock down the columns to the individuals that should be entering in the data. This will allow us to make that person responsible for their column.
-
All you need to know about Community Champions 💡 (Updated February 2025)
➡️ Meet our newest class of Champions for January 2025! Hello all! Thought I’d pop in, especially for our new members, to talk a little about the Community Champions program. Fun fact: It was called Community Rockstars during its early days! Before I get ahead of myself: My name is Alison if we haven’t connected yet, and…
-
[GIVEAWAY CLOSED] [RECAP] Jumpstart 2025: Celebrating Community + BONUS chance to win swag!
There’s no better way to kick off a new year than with Community! On behalf of the entire team, thank you all for joining us at Jumpstart 2025 with Community during one of the two showings. We got to look back at everything we accomplished together while peering ahead at so many exciting things to come, including our 10…