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!!
Solved
Reformatting Rollup Date Range
+12Best answer by TheTimeSavingCo
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
+31re: 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
Login to the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.