Skip to main content

I have a rollup cell that is pulling a range of data from another sheet.  Is there a way to:

1) Format these so it's easier to read : MM/DD/YY-MM/DD/YY 
2) Format these so I can create a calendar view that would show these dates in a row on the calendar?

Thanks!!

re: 1) Format these so it's easier to read : MM/DD/YY-MM/DD/YY
In your other sheet, create a formula field and use DATETIME_FORMAT() to display the date as MM/DD/YYYY, and then point your rollup at the new formula field

---re: 2) Format these so I can create a calendar view that would show these dates in a row on the calendar?

Hmm, try creating two rollup fields, one with MIN() and one with MAX(), both pointed at the date field.  This should give you the start and end date of the event.  You should be able to use those two new formula fields in your calendar view then

Great, thank you!!

Reply


Terms & Conditions