-
Return a value based on looking at two cells
Hello SS Community, I am having a bit of formula writing block. I am trying to return a value based on looking at two cells. For example in the picture below. If Onboarding Complete Date is blank and I9 Complete Date is blank, change the OB Status column to 'Awaiting Talent Paperwork' If Onboarding Completed Date isโฆ
-
What's wrong with this formula?
It returns only Complete or Not Started. =IF([% Complete]@row = "1", "Complete", IF([% Complete]@row = "75", "End in Sight", IF([% Complete]@row = "50", "Work in Progress", IF([% Complete]@row = "25", "Just Started", "Not Started"))))
-
Using COUNTIF children to change a Status with multi criteria
Hello! In our Timing and Action we have a formula that indicates the status of a Parent row based off the cumulative Status choices (Not Started, In Progress, Complete, N/A) of the Children Rows below it. How do I get the formula to register the Parent Row 'Complete" when the CHILDREN Rows = both Complete and N/A I want toโฆ
-
Nested COUNTIFS
I'm trying to count the matching items in two cells to a reference in another sheet. Individually they work with COUNTIF and produce the associated result but then I want to test both it comes back with "0". =COUNTIF({DNAC Adoption Range 1}, Partner106) = counts the correct partner name =COUNTIF({DNAC Adoption Range 1},โฆ
-
COUNTIFS Function
Hello everyone, Need some help with this formula, thinking i have too much going on here? =COUNTIFS({Environmental Incident Tracking Range 1}, AND({Environmental Incident Tracking Range 3} = 1, YEAR({Environmental Incident Tracking Range 4} = 2020, {Environmental Incident Tracking Range 1}, "Leak"))) Environmental Incidentโฆ
-
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โฆ
-
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โฆ
-
Show 100%
How to show 100% if "0" is the answer on the formula below. =IFERROR(SUM([121-365 Days]1:[>365 Days]@row) / [Grand Total]@row, 0) Thanks.
-
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โฆ
-
Count the amount of cells with value, if another column contains "Production"
Hello! I need to make the count of cells that contains information (any info), of the column "Area of design", just when the cell in the column "Part level" contains "Production".