If you could provide a read only link with example base and example data it would be very useful in helping you troubleshoot this issue!
@Mitchell_Knox
The reason it’s not working is because lookup fields are arrays, not numbers nor strings of text.
If you’re certain that your lookup field will always contain one value only (which is what’s needed in your situation), then you can turn your lookup into a string of text like this:
{Your Lookup Field} & ""
That might be enough for your formula to work, but if that doesn’t work, then you can often turn text into numbers with this formula:
VALUE({Your Lookup Field} & "")
Hope this helps! If you’d like to hire an expert Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld
Try to use this formula:
DATETIME_FORMAT(
SET_TIMEZONE(
DATEADD({Created}, {Days (from Boosts)} & "", 'days'),
{Tutor Timezone (from Tutor)} & ""
)
,'DD MMM YYYY'
)
Explanation:
Lookup fields are array values, so for this formula convert them into strings will do the trick.
This is done by adding & "" to the formula
{Days (from Boosts)} & ""
I hope this helps! If you need help implementing this or any other solution, feel free to schedule a free call with me.
- Juan, code and no-code solutions expert