Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Mar 27, 2024 06:04 AM
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! Go to Solution.
Mar 27, 2024 09:11 PM
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
Mar 27, 2024 09:11 PM
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
Mar 28, 2024 03:19 AM
Great, thank you!!