I’ve been having tons of fun learning how to handle DATETIME and IF() and SWITCH(), but I can’t figure this one out. I am measuring the difference in weeks between two calculated dates, and that bit is OK, but I want to replace all of the weeks in t...
I am trying to determine if an appointment date (stored as UTC) is on the same day or a different day depending on the timezone.
I think I know how to do this with an IF statement in general:
IF(“Date in CTZ1”=“Date in CTZ2",“same”,“different”)
but I...
Mohamed_Swellam:
You almost got it the first time :slightly_smiling_face:
:laughing: Yup I tried everything but the right way! Thanks so much for the help and the new lesson in formulas!
My new resolution:
[sic] complex formulae should be...
Mohamed_Swellam:
just before this formula, add <0
Thanks for the suggestion, and I’m still doing this incorrectly:
IF(DATETIME_DIFF({IBP Ends}, TODAY()<0,'complete') DATETIME_DIFF({IBP Ends}, TODAY(),'weeks')
When I use:
IF({IBP Ends}<0, TODAY...
Having played around with the CSV upload to Zapier, I’d have to say that my alternative option of having an individual timezone column for each colleague works better if using Zapier.
I also found this which seems to be related; at least it has relev...
Great question - and depending on your use case this would be easy or not. I know you can upload a csv to zapier now but have to confess I haven’t tried it. I will this weekend and will update this post.
I think the OP indicated that the emails woul...
Zapier isn’t able to read or manipulate those texts that are connected to another table, since the long code you are seeing is an internal code to Airtable.
To show the actual code from a referenced cell in Airtable, you may need an extra column usin...
