-
Split-screen auto populate?
Hello all! I have a smartsheet that is always open in our warehouse to let the guys know when an item needs to be shipped; the line is added by our procurement team. After the warehouse personnel complete a shipment, they mark the status of that line as complete and save. The line then gets crossed out but stays in the…
-
Problems with conditional formatting
Hi, I am trying to apply conditional formatting to a cell if it is blank. The issue I am having is that the cells I want to apply this to have a formula in them (=IF(Name16 <> "XXX", "N/A", ""). The conditional formatting doesn't pick up the "" as being blank. Have tried a few workarounds but haven't found a solution that…
-
Expanding and Collapsing Hierarchy/Outline levels
Very much would like to have the ability to expand the hierarchy to a particluar level such as 1,2,3 ... ALL. For my applicaiton Level 1 is PROGRAM, Level 2 is PROJECT, Level 3 is milestone, etc. I need to see the entire sheet open to a particular level. Looking for something that exists in Excel as well as all "outline…
-
Nested Formulas
I am attempting to use the nesting formulas to auto generate text showing the status of a project step that is co-dependent on several previous steps, but only when the previous steps have been selected. For instance,we have an "Assigned" column which is just a check box, a column which indicates if that task is complete…
-
HELP! RYB Color Change Based on Dates
Hello everyone, I am currently using this: =IF(NOT(ISBLANK(Completion4)), IF([Estimated End]4 >= Completion4, "Green", IF(NOT(ISBLANK(Completion4)), IF([Estimated End]4 < Completion4, "Red")))) Which is working but I try to add this: IF(ISBLANK(Completion3), IF(NOT(ISBLANK(Supervisor4)), "Yellow" And it doesn't work, I'm…
-
Conditional Formatting Question?
Hello! I'm very new to smartsheets and have been using them for probably 6 months and I have to create a sheet with conditional formatting where the date drives the coloring of the entire row. I've watched the video's and searched Q&A, however; I feel like my questions are specific to the work I'm doing. Is there any other…
-
Formula Improvement
Hello! I am trying to write a formula to count whether a group is active or inactive and how many groups are active. There are a couple conditions though, column1: the cell must not be blank (if it blank, it should not count), column2 **is a dropdown menu with three choices** : the cell must either be blank or contain…
-
Vertical Text Alignment
For a multi column checksheet, I want to have the header text vertically aligned to keep the column width to the "X" width. Is there a method to accomplish this, it is that way in my spreadsheet but would not import correctly. Thanks Example P A R C O C P E O P S T E E D D X X
-
Conditional Formatting to change status?
Hi, I'd like to be able to change the row status (planning/in progress/complete/overdue) depending on a required date in another column in that same row. I have a report set up to report all overdue tasks and I'ld like to automate it more to change the status of all overdue tasks without any input from me. Is this…
-
Changing cell to "0" if checkbox is checked
Wondering if it is possible to change a cell to "0" if the checkbox is checked. I'm assuming a formula will need to be used since I was unable to find it in the conditional formatting. Thank you for your help in advance.