-
Parent Health Status of Children Rows Based On If Certain Criteria Is Met
Hello, I have a Gender column with these options: Female, Male, Transgender, Non-binary/non-conforming, Prefer not to respond I need the parent row to reflect a status of RED ball if there is no 'Female' represented in any of the children. I currently have this formula, but feel I'm missing significant COUNTIF references:…
-
Pulling in Established Data from 1 Sheet into Another Sheet as a Drop Down
Hi All! I have one base sheet of HR job posting with several descriptive column headers, and one of the columns is a Job ID number. Job ID numbers are hand-keyed and unique. I have a second sheet of candidate names and I want to be able to select an active job ID to assign to that candidate from the original base sheet of…
-
Copy a cell from another sheet with criteria from another column that has multiple same entries
I have two sheet, Test of Project Intake, which has many columns of data. I want to copy the Project Name column when the Lookup Combo has "Pending-PPRB". The problem i am having is the Lookup Combo column has many entries of "Pending-PPRB". For each of those entries I want to copy the Project Name to the New Projects…
-
100% in conditional formatting
Hi, how can I express 'greater than 100%' in conditional formatting? This is my column: And this is the conditional formatting command I'm using: I've tried 0.01, 1, 1.0 and 100, and it just returns everything red. Any help would be very much appreciated.
-
3 row automation
I am new to SmartSheet, so I'm not sure what it's capable of. I want to have a template of 3 rows [2 indented behind the first] that I can link to a form for adding rooms/lots to an existing job. Or, instead of creating a template, automate the creation of indented rows upon row creation from a form. I guess this might…
-
Is there a formula in smartsheet that would create a 2 way link between cells?
Hello, I have multiple sheets that I would like to link all into one Master Sheet. I want the cells to have a two linking methods between each other. If a cell changes in the Master Sheet, I want it to reflect to the other sheets and if the other sheet decides to change the cells, it would reflect back to the Master Sheet.…
-
Needing Help with an IF TODAY formula
After reading countless articles and trying countless combos, I still can't get this formula to work. I am trying to give a 30 day notice to an expiration day with a status column. =IF([TIPS Expiration]-TODAY()>30,"Green", IF[TIPS Expiration]-TODAY()<30,"Yellow"))
-
Budget v. Invoice Cost Codes
I have two Smartsheets. Sheet 1 is my budget broken down into various cost codes. Sheet 2 is a log of all my invoices with cost codes and amounts assigned to each invoice. I am trying to take the amount from each invoice and have them populate in my budget according to their cost codes. The budget amounts for each cost…
-
Error w/ Formula (#INVALID)
Hi Formula Friends - Can you help me identify what's going wrong with the following formula (Reference Cell: 'Count1'): =COUNTIFS([Work Related Exp]:[Work Related Exp], 1, Created:Created, AND(DATEONLY(@cell) >= [Encounter Date]$2, DATEONLY(@cell) <= [Date Resulted]$2)) I was working a few days ago; however, something…
-
Email / Name reference formula help
Hi, I am trying to create a formula where an entered email address automatically populates the person's name associated with that email in an adjacent column (see below). The data is referenced from a master sheet of people's email/name contact information. I have this function in a different sheet and it works perfectly…
