Skip to main content

Multiple date roll-up to long text bullet format

  • January 27, 2023
  • 0 replies
  • 9 views

Scott_Gardner1
Forum|alt.badge.img+15

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 

IF(
    COUNTALL(ARRAYCOMPACT(values)), 
    "• "  & ARRAYJOIN(ARRAYCOMPACT(values),"\n• ")
 )

 Thank you!

Scott