# Formula GoogleCalendar::BusyTimes blank in column (works on canvas)

**URL:** <https://connect.superhuman.com/t/formula-googlecalendar-busytimes-blank-in-column-works-on-canvas/15541>\
**Category:** Bugs\
**Created:** [April 29, 2020, 2:38am UTC](https://connect.superhuman.com/t/formula-googlecalendar-busytimes-blank-in-column-works-on-canvas/15541 "2020-04-29T02:38:56Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Ryan\_Martens](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/ryan_martens/32/11616_2.png) [@Ryan\_Martens](https://connect.superhuman.com/u/Ryan_Martens)\
**Post date:** [April 29, 2020, 2:38am UTC](https://connect.superhuman.com/t/formula-googlecalendar-busytimes-blank-in-column-works-on-canvas/15541/1 "2020-04-29T02:38:56Z")

</div>

I’m trying to use the [BusyTimes](https://coda.io/formulas#GoogleCalendar::BusyTimes) formula from the Google Calendar pack to filter out all rows in a table that have an overlap with my “Ryan Martens Default” GCal. When I use the formula directly on the canvas, it works as expected, returning a list of event start times within the specified range. Strangely, it also works perfectly in the formula preview (see screenshot below), but the column value stubbornly remains `[]` for every single row, whether or not there are overlapping times.

 ![image](https://global.discourse-cdn.com/coda1/original/2X/5/56a0a46b7120af37d6300e4239203c0690447386.png)

I’ve tried refreshing the connection and extending the date range of the formula. It consistently works fine on the canvas (even pulling in the exact same row data via formula) but does not work in the column.

Any suggestions for workaround while this gets fixed?

---

<div class="post-metadata">

**Author:** ![Ben\_Lee](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/ben_lee/32/49867_2.png) [@Ben\_Lee](https://connect.superhuman.com/u/Ben_Lee)\
**Post date:** [April 29, 2020, 12:56pm UTC](https://connect.superhuman.com/t/formula-googlecalendar-busytimes-blank-in-column-works-on-canvas/15541/2 "2020-04-29T12:56:52Z")

</div>

I’m not able to re-create this on my side. I set up a meeting in a table and chose a time that overlaps with another meeting and it shows up properly. If you’d like to write into support using the “?” icon at the bottom right of the doc, then also share the doc with support, we can take a look there.

 ![google-calendar-busy-times](https://global.discourse-cdn.com/coda1/original/2X/e/efb5e13280942d4dd69bdfa763f142651411e4a2.gif)

---

<div class="post-metadata">

**Author:** ![Ryan\_Martens](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/ryan_martens/32/11616_2.png) [@Ryan\_Martens](https://connect.superhuman.com/u/Ryan_Martens)\
**Post date:** [May 8, 2020, 5:03am UTC](https://connect.superhuman.com/t/formula-googlecalendar-busytimes-blank-in-column-works-on-canvas/15541/3 "2020-05-08T05:03:18Z")

</div>

I opened the doc up again after a few days and it’s magically working. Not sure what happened but glad it’s working now 🙂
