Hello! @Melanie_E_Magdalena and I built and supported just such a plugin with a team of 15 using for support. It was a massive productivity machine! We are familiar with both API’s and have custom code to connect the two. We’d love to have a meeting ...

Hello! The reason for this is the IF statement needs to be wrapped in a SET_TIMEZONE and declare the desired timezone. You can find those here: https://support.airtable.com/hc/en-us/articles/216141558-Supported-timezones-for-SET-TIMEZONE

Howdy - @Melanie_E_Magdalena and I had a crack at this for you - not sure how variable your data is, but with the samples you gave, try this: LEFT(RIGHT(Name,5),1) where {Name} = the field name Hope that helps!! Grant

Thank you!!! The brain damage I’ve received getting data out of Shopify reliably…

:trophy: This is an absolutely brilliant solution for the hard to reach handoff - I love it!