Hi @Abbey_Matye,
Perhaps my ridiculous formula in THIS POST will be of use :man_shrugging:t2: .
Hi @Abbey_Matye,
Perhaps my ridiculous formula in THIS POST will be of use :man_shrugging:t2: .
Hi! Based on the use case description, I feel like this could work! I’m having issues getting the formula to be valid in my base though. I only copied up to 30 days, because we won’t have folks have more nights of stay than that, and I filled in the field areas for {Start Date}, {End Date}, and {Length in Days}, but I’m having issues finding what would correlate to “{Cancelled On},{Cncltn Recorded By}”. Are you able to clarify?
If it helps, this is how I have the table set up:

I used Check In as {Start Date}, Check Out as {End Date} and Number of Room Nights as {Length in Days}.
Hi! Based on the use case description, I feel like this could work! I’m having issues getting the formula to be valid in my base though. I only copied up to 30 days, because we won’t have folks have more nights of stay than that, and I filled in the field areas for {Start Date}, {End Date}, and {Length in Days}, but I’m having issues finding what would correlate to “{Cancelled On},{Cncltn Recorded By}”. Are you able to clarify?
If it helps, this is how I have the table set up:

I used Check In as {Start Date}, Check Out as {End Date} and Number of Room Nights as {Length in Days}.
I would just delete the surrounding IF()
and the top two lines of the formula I posted.
Hi @Abbey_Matye,
Perhaps my ridiculous formula in THIS POST will be of use :man_shrugging:t2: .
Hey @Jeremy_Oglesby - Could you reshare the link to your formula? The link in "THIS POST" is taking me to a general Airtable community support page. Thank you so much!
Hey @Jeremy_Oglesby - Could you reshare the link to your formula? The link in "THIS POST" is taking me to a general Airtable community support page. Thank you so much!
Hey @summerdickey - Airtable changed forum services at the end of November, and apparently all the cross-referencing post links in the forum no longer work.
Here's the post I was linking to:
https://community.airtable.com/t5/product-ideas/new-formula-field-functions/idc-p/36089/highlight/true#M2253
Hey @summerdickey - Airtable changed forum services at the end of November, and apparently all the cross-referencing post links in the forum no longer work.
Here's the post I was linking to:
https://community.airtable.com/t5/product-ideas/new-formula-field-functions/idc-p/36089/highlight/true#M2253
Ah, thanks so much! Will give this a try 🙂