clairehunter✭✭

@JamesB It is still saying "the column formula syntax is incorrect".

@Genevieve P. Yes, this makes sense. It would not be optimal conditions to have to manually enter the formula into each parent formula as we will have many being added each day. Is there a way to tell the formula to allow edits while doing the action I suggested?

@Andrée Starå Thanks so much!

@LydiaBR I know this is so so late, but I was wondering if you inevitably switched to another platform or found a way to make it work? I am running into the same issue.

@Paul Newcome Oh I apologize. I was confused. It seems that the formula =IF(COUNT(CHILDREN()) = 0, IF([B/O]@row = 1, "", IF(Status@row = "In Progress", "", IF(Status@row = "Not Started", "⚫️", IF(Status@row = "Completed", "")))), JOIN(DISTINCT(COLLECT(CHILDREN(), CHILDREN(), @cell <> "")))) worked perfectly!

@JamesB That works PERFECTLY! Thank you so so much!

@Paul Newcome Okay, I will try to explain to the best of my ability, lol. I am creating an "Open Orders" sheet. I am wanting the employees who use this sheet to view strictly in card view with the ability to drag from "In Progress" to "Completed" to "Backorder", etc. When the "Status" field changes, I have a formula set up…

@Paul Newcome Hello Paul, I apologize, I am most likely doing something incorrectly, but it doesn't seem to be working. I add it to the beginning of my preexisting formula and it returns saying the syntax is not correct. I also tried in a column without a preexisting formula and it returns as #UNPARSEABLE.

Hello @Paul Newcome This looks perfect! My only additional question would be, I am trying to make it a column formula as you mentioned above. I want it to be added to this preexisting column formula: (if that's possible, of course.) =IF([B/O]@row = 1, "", IF(Status@row = "In Progress", "", IF(Status@row = "Not Started",…

Okay. I am wondering if I could assign an emoji and do something like the ss below. How would I create the formula that would automatically populate parent fields with all of the values displayed in the children cells? (Orange row is indented parent row.)