Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums.
Discussion List
Can a Licensed User in the Team Plan view the Admins workspaces and Sheets?
Hi, I've purchased the team plan and apart from me, I've added another project manager from my team as a licensed user so she can create sheets. This puts me at 2 of the 3 licensed users. My question is that can I prevent her from view a specific workspace in the account because even though she is a licensed user on my…
Archiving Workspace folders
Is there a way to archive folders in Workspace I no longer need in the Workspace drop down?
Modify Calendar View?
I'm trying to take a list of dates and associated activities - potentially up to 15 per day -- and display them in a calendar format...either traditional or agenda layout. I have curriculum maps -- material we will cover each day for 6-8 weeks - listed out in spreadsheet format and then want to turn that into something…
Comparing Targets and Actual's
I have a data set where the targets are set at the start of the year and as the year progresses actuals are loaded (through Webform) which appear on a different row. I am trying to calculate the performance each month (Actuals / Target) but I dont know how to calculate this when the values are on different rows. I'm sure…
i am trying to set up an It Service Request Tracker - Need workflow approval
Ii am trying to set up an It Service Request Tracker that can incorporate the request being sent to specififc individuals for approval. In other words before a lower level user can submit a request, Mgmt needs to review and approve it. Can that be done?
Hide Column in Template
Hello, I have a sheet that I would like to convert to a template. I would like to hide several columns as they will auto calculate once a box (in another column) is checked and they are therefore unnecessary for the end user to see. Is it possible to keep a column hidden once it is converted to a template? Thank you!
Feature Request: Expanding Notification selection(On specific contact list selection)
In the future it would be nice if it would be possible to send a notification email to for example a developer if a help desk ticket was given to him to fix for example.
reminder for update requests
Hi there, is there a way to remind users to update requests if they haven't done it. Thks Peter
Prevent inheriting formatting from previous row.
I have a sheet where the first row is populated with instructions on how to complete each column (becasue the column title text is so limited - but i digress). That row is formatted in a green color to set it off from the actual data rows. The problem is, when I go to enter data in the next row (2), that row automatically…
Counting Formula
What formula do I use to count how many times a name shows up in a column? For example: I have a column titled "Last Name" I need to keep a running count of how many times "Smith" shows up in this column.