Christina09✭✭✭✭✭✭

@Samuel Mueller I modified the formula, and it's got close, but row 18 -20 is not populating "Nathan" =IF(IF(COUNTIFS(Select:Select, 1, [Column5]:[Column5], ISNUMBER(@cell), ID:ID, ID@row) >= 1, JOIN(COLLECT(Assignee:Assignee, [Column5]:[Column5], ISNUMBER(@cell), Select:Select, 1, ID:ID, ID@row), ""),…

@Samuel Mueller You are awesome! The color formula worked!! :)

@Samuel Mueller I updated the new formula, but it's still not populating the correct name

Hi @Samuel Mueller Unfortunately, it populates and joins more than one name (green txt). I was hoping it can populate the red txt in outcome column.

@Samuel Mueller Thanks for helping. Is it possible to modify the formula so it'll only show up a name that has a check on the Select column? And if none within the same ID are selected, it'll populate "Chris". I tried modifying it to this, but it doesn't populate properly (see txt in green): =IF(COUNTIFS(Select:Select, 1,…

Hi @Samuel Mueller Thank you! It works. Ya, Sam wouldn't be assigned Do you happen to know if there is a formula that can alternatively assign 0 or 1 based on the ID# (example highlighted in red)? I wanted to use a conditional format to highlight the row so it's easier to view for the same ID.

Hi @Coach Barnett, Yes, you can add a helper column with a unique ID to have it index/match the master sheet. Here's a link for reference: https://community.smartsheet.com/discussion/32686/auto-filling-a-cell-based-on-the-entry-in-another-cell

@mragans23 I added a helper column for ID# since the formula won't match if it's a number. =VALUE([ID#]@row) =IF(MAX(COLLECT([Start Date]:[Start Date]; [ID# Helper]:[ID# Helper]; [ID#]@row)) = [Start Date]@row; 1) Hope that helps.

HI @Stwillis, For the first one, here is the formula for it: =IF(COUNTIF(CHILDREN(), @cell) > 0, 1) If it's more than 0 checked, it'll check the parent checkbox. This is the second formula for if you want the parent row checkbox to check when all children row checkboxes are checked. =IF(COUNTIFS(CHILDREN(), 1) =…

Hi @Pedro Robles Try this: =COUNTIFS([Priority]:[Priority], = "Low", [Status]:[Status], = "Closed") If it doesn't work, can you share a screenshot of the sheet?