-
Prevent Sorting on Shared Sheet
We have a lot of users using Smartsheet as a tracker. Team members sort and then filter to get the information they need. The problem is that the sort affects all of the other users who are sorting on different things. Is there a way to have the sort only apply to the user that is sorting? Similar to the way that filters…
-
Forms & automation
Hello, I use Smartsheets in a Higher Education setting. I have one sheet (Sheet A) for a list of students this sheet contains their student id numbers, email addresses, as well as other helpful information. I built a If Yes/If No check column on this sheet as well. My next sheet (sheet B) is a form that is asking is the…
-
Getting error - need help!
Error occurs when opening Vault Apps in Smartsheet WorkApps. The app fails to load and displays an error message despite logging out and back in. Issue has been ongoing since last Monday
-
Dropdown values aren't showing in form using the new dropdown link to sheet
I used the new feature with the dropdown column type where you can reference a single source sheet for dropdown values (thank you, Smartsheet!), but when I am creating my form, it doesn't show that field in the form —- see error message below. Has anybody experienced this and if so, what did you do?
-
Can an admin of a sheet be from a different organization?
I have shared sheets and dashboards with people outside of my organization, and one has a paid license. Would I be able to grant admin access to this licensed user to their sheet? Or would the ownership of the space by one organization limit the admin accessibility of someone from outside?
-
Enable Dynamic Variables in Email Subject Lines for ‘Send as Attachment’ Feature
Many users need to automate report deliveries with contextual information (e.g., month and year) in the subject line, similar to how Automations allow cell value references. I propose adding support for dynamic variables (e.g., {{ColumnName}} or date placeholders) in the email subject and file name when using the “Send as…
-
Merged: elapsed days as a predecessor lag
This discussion has been merged.
-
Linked Dropdown Columns
Good afternoon, I am trying to utilize Linked Dropdown Columns for a manual process we have. We have many sheets that use a "Client Name" column with a dropdown list. Whenever a new client comes on or exits, we have to manually update every sheet that has a Client Name column and update the dropdown list. We do not have…
-
Creating a report frm several sheets to assign tasks without adding an assigned column to each sheet
I have a collection of sheets (10-12) that all have projects in various stages that need a status review/update. This is a temporary process and I need to be able to assign each project to an employee, but these sheets don’t have an assignment column already built in them. Is there a way to set up an assignment system…
-
I occasionally get #ERROR results from formulas that are only fixed by a page refresh
Occasionally I have been getting #ERROR or other error messages as a formula result in cells that previously return a valid result, and nothing related to that cell or the cells that are referenced changed. The only thing that finally fixes this is to do a hard page refresh. The attached images show this, and the only…