-
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…
-
No restrict to dropdown values on form
On the sheet, if I dont check on "Restrict to dropdown values only", then I can type a new value into the dropdown column. But on the form, I cannot type a new value, even I choose not to check "Restrict to dropdown values only" on the column properties. Is there any way that I can create a dropdown field on form and still…
-
How to automate putting rows (based on conditions) of one sheet to a second sheet?
Hi, My sheet 1 has a structure with column 1, 2, and 3. My sheet 2 has a structure with the same columns as sheet 1 - column 1, 2, and 3 - plus new columns column 4 and 5. Based on values in column 2 in sheet 1, I would like to export the row in sheet 1 that satisfies a condition, to sheet 2. Once sheet 2 is updated, I…
-
New Graph functionality
Hi, We have been pining after graph functionality for a while in smartsheet and thought the latest release may have addressed this. Could anyone suggest a way to address the following (please see attached picture) We would like to add a target line to a bar graph to visually see where employees are over allocated.…