Skip to main content

I have a rollup formula that returns a bullet pointed listed, which works beautifully (supplied by this incredible community - thanks!). I need to concatenate that with additional information though and am at a total loss.  This is my current output. 

 

I have an additional column with the tentative open date that I'd like to add to the list in Pending Branches.  My current formula:  

 

IF(
values,
IF(
COUNTALL(values) = 1,
"• " & TRIM("" & values),
IF(
COUNTALL(values) > 1,
"• " &
TRIM(
ARRAYJOIN(
values, "\n• "
)
)
)
)
)
 
Please help!!! And thank you 🙂
 

Hey @LeighAnnMoltz! 

Great to see you back! Happy to see that my formula has been holding up well!
I'm slightly confused at what the result you're looking for looks like. Could you provide an example of what you'd like your rollup to return?

The more details you can provide, the better!

HAH!! Hello again. I've used that formula in a thousand other places - it's perfect.  

 

YES! Hopefully this helps. I want to keep my bullet point list, but for each bullet point, I'd like to add the open date (tracked in another column).  I suppose I could add a formula field that does that in the original data and just rollup that formula field instead of the branch name. If I can keep it all in one column, that's my preference though.  

Actually .... I hadn't considered that, I'll do that. A concatenate formula in the original data and I"ll just roll up that field in my pending branch column.  

 

Thanks 😄 

Reply


Terms & Conditions