-
Conditional Formatting if Checkbox is Checked
Hello everyone, I created a checkbox column with 3 cells set to toggle on and off conditional formatting rules. My idea is to paint certain cells if certain conditions are met AND one of the 3 cells is checked. I'm doing this mainly for aesthetic purposes as I don't want to have my sheet multicolored all of the time. Using…
-
INDEX, MATCH, AND formula
I am trying to create an Index / Match cross-sheet formula if two cross-sheet criteria are met. Sheet One displays the Sales Reps for New and Modified Items: I want to display the Item Rep for NEW item types. The formula entered on Sheet Two is: =IF(AND(MATCH(Item1, {SHEET ONE_ITEM}, 0), MATCH("NEW", {SHEET ONE_ITEM…
-
Setting Up Automated Transfers between Sheets
Hi all, I'm trying to sort out if it's possible to have information automatically transferred from one sheet to another. Essentially, I'm hoping to create an automated archive that absorbs all information in our primary sheet once an item has been fully addressed. I haven't come across anything in the training videos that…
-
Color Scale
I read an old thread from 2018 about this, but is there a plan to provide users the ability to do conditional formatting using a RYG color scale based on high/low values?
-
Idea on connecting two Smartsheets?
I have two sheet that i want to reference and update each other. They both follow similar formatting, with one being more of a log/reference for the other. I would like one list to dynamically update the other. How would i do this? Items list - I have a items list that will show an overview of purchase orders to be done…
-
Reference a date based on Percentage complete
In Sheet One, there are 25 products assigned to 4 Product Types. Each Product has an expected delivery and an actual delivery date. In Sheet Two, we want to add the dates associated with the percentage complete. The existing formulas provide the percentages and totals but how can I add the dates for the milestones. For…
-
Affect multiple columns with one conditional formatting rule?
I have four columns, A, B, C, and D. If the entry in column A is "NO", the I want columns B, C, and D (within the same row) to be blacked out. The only way I can see being able to do this is to put a rule in for each column. Is it (would it) be possible to check multiple columns in the selection field when creating the…
-
Adding an additional requirement to a formula
We have been using this formula to add up the hours spent working specific clients -- been working fine. We have also been asking what category of work they have been completing at these clients but haven't been utilizing the data. =SUMIF({Kinsman - Job#1}, [Scope of Work]@row, {Kinsman - Hours#1}) I now need to add an…
-
Summary Fields: Percentage of Completed Checkboxes
I'm very new to Smartsheet and hoping someone can help me. I have created a checklist, with different categories divided up by parent rows, and the tasks listed as children under the categories. I have a checkbox column and each task (in the children rows) has a checkbox. I have figured out how to calculate the percentage…
-
Borders visibility
I am trying to figure out how to control the borders in SS? They dont print well and the grind I am using needs to be seen ?
