-
Auto format drop down menu
Hello everyone, I am trying to set an auto format for drop down menu to give select options from another column's drop down menu. Does anyone know how I can accomplish this? Example: If Assignment is Compliance give me the 5 specific compliance options from a list of 20 on another column. Thanks in advance,
-
Sharing Question -
A workspace was shared with me, and I was made an editor who can share. For a specific SmartSheet in a subfolder underneath that workspace - how do I request to the owner that I want to be an admin of that SmartSheet in order to set up conditional formatting, send automatic alerts, etc.? I do not see any option of making a…
-
Highlight Recently Modified Fields
Is it possible to create a condition that highlights only those fields that have been modified within a specific date range? I would like the highlighting to appear the way the notification email exclusively highlights new or changed fields.
-
Help with nested If formulat
These formulas work independently. I am attempting to combine them into one nested if formula. 1) if the %complete is full, status is green: =IF([% Complete]10 = "Full", "Green" , "Red") 2) if the finish date is greater thant today, status is green: =IF(Finish10 > TODAY(), "Green") 3) if %complete is full and finish date…
-
Subtasks in CardView
Hi Their I currently have 4 sheets which represent 4 departments in a card view ( running multiple kanbans ), off a card may come a subtask that needs to be delivered by another team. i am creating the subtask which creates the additional card on the main sheet, but when i move the subtask to the relevant department (…
-
Internet explorer stops working while trying to open an existing sheet
I have a new user that is encountering an issue when she tries to open an existing sheet. She retrieves an error that Internet Explorer has stopped working. she has to close and restart. the sheet is approximately 600 lines and looks like a standard project sheet. She is able to open other sheets without an issue but it is…
-
Totals By Date
Hello, Has anyone successfully used dates to pull totals? I'm trying to do the following: Columns: Start Date | End Date | Status 1/2/18 1/10/18 Completed 1/5/18 1/7/18 Completed 1/5/18 Open 2/8/18 2/15/18 Completed 2/16/18 2/20/18 Cancelled Output: Total 'Completed' for January 2018 = I'm wanting to use the dates and…
-
Bug with checkbox fields
I created a copy of a sheet that contained checkbox columns (restricted to checkbox only) and deleted the existing data. This then made the checkbox fields inoperable as it didn't accept the checkbox (even on new rows).
-
Updating rows without re-running filters
Hi. I'm an active user and have a filter that hides "done" rows. As I'm working, I frequently marking stuff as done, but it rarely if ever hides the rows with that new information. In order to make the rows actually hide, I need to turn off the filter (which causes a page reload), and then turn it back on again (yet…
-
Filtered Views for External Collaborators
Hello, i am not sure what the best way is to accomplish this. I have a smartsheet that i would like to collaborate with outside vendors. I would like to avoid chopping up the data and giving every vendor their own sheet. I will be adding new data weekly. Update request won't work because they could be getting 20+ lines at…