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