We want to create a new workspace but only want certain people to be able to access that workspace. Will system Admins be able to see the work space if there is some data we don't want some of the system admin to view
Hi, My teams work concurrently across multiple projects. Is there a way to combine status update requests for tasks across multiple sheets so that they receive a consolidated update request for all projects? I have created a "Current User Report" which shows tasks across all projects for each user, but am having difficulty…
Hi - Is there a way to automatically reset a date when a task is complete? So when a task is done I click the check box and it will automatically reset the due date to the next business day on daily recurring tasks. Thank you!
I have a file with two workflows. The first workflow is an update request which is sent on Thursday's. The other workflow is to notify the owner if a cell was not updated as requested. To trigger this workflow I created the following helper columns: Modified: auto number with date formula Modified date: date only from the…
Hi, What formula gives me the same value as the above filter? Would need something like COUNT IF {Range 1} Is Not in the last (x) days Thank you!
I have a column that organizes my tasks (rows) by priority. So, my highest priority is 1 and my lowest is 10, etc. When I add a new task to the spreadsheet and I decide that it is now the highest priority, I want to put 1 in the "Priority" column and then everything else in that column goes down one number sequentially.…
Hi All picking your brain here on formulas cant make it work, I am looking to count if: In my column A the name is DC380 and if corresponding at the value in column A, the value in column B and C is "not done", see an example below: DC status A Status B DC480 approved not done DC280 approved not done DC380 approved not…
I'm trying to figure out if there is a formula that can be used with forms that would alert someone if they pick a date that is taken already. have a sheet with a list of class dates, and I'm using a form to collect information from instructors that will tell me when they would like to hold a class, but if they select a…
I need to create a form that allows folks to request materials from inventory; part, description, quantity, etc. when they submit the form it should then go to the Materials team to fulfill. how do i set the form up so that they can select multiple parts/quantities on the same form with out having to submit one per item?…
Hi. I have active contacts from my contact list in Children row. I would like to bring them together in one cell in parent row. I understand function COLLECT needs to be used with another function. If it is JOIN, then it lists me all the names but they are not active contacts anymore. Is there a possibility to keep them…
Hello all, I have a question on how I can set up a roster for my team. I want to have a sheet with "locked positions" and be able to link/connect a person to that from my roster. This is what I'm aming for: Column: Drivers Row: Driver # Driver 1 Driver 2 Driver 3 Column: Loaders Row. Loader# Loader 1 Loader 2 Column:…
I'm wondering if I only grant permission to a handful of assets within a workspace to an individual, if that individual will have the workspace panel functionality.
Is it possible to show one row per brand in my report? i only want to show here is the what is the latest
Help shape the future of Smartsheet. Share your ideas and feature requests.