Help

Multiple date roll-up to long text bullet format

Topic Labels: Formulas
293 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Scott_Gardner1
7 - App Architect
7 - App Architect

Hello-

I am trying to roll up 10 date fields that are all deadline dates to a long text field in a bullet format.

Ideally I would want the field name to be visible as well as the date like this (Field name/Date):

- Designer due date: 1-2-23

- Submittal due date: 1-15-23

- Final proofing due date: 1-30-23

I saw this from 

Scott_Gardner1_0-1674803850944.jpeg
IF(
    COUNTALL(ARRAYCOMPACT(values)), 
    "• "  & ARRAYJOIN(ARRAYCOMPACT(values),"\n• ")
 )

 Thank you!

Scott

0 Replies 0