Dear fellow airtable wizards,
Today my quest has put me up to a challenge I hope you guys can help me with.
Short backstory: We offer courses which people can subscribe to (their record enters the base using forms) The first course starts the 3rd of ...
I’m looking for a formula that goes like this:
IF: Created time is in week no. 40 then “A”
IF: Created time is in week no. 41 then “B”
IF: Created time is in week no. 42 then “C”
I tried to do it myself… Nearly had it (I think) But I got...
My question is simple… (hopefully the solution also)
I need a formula who automaticly tells me what date it is next Tuesday. On Wednesday it needs to update itself to next Tuesday.
Thanks in advance!
Dear wizards of Airtable,
We run a program for kids this summer. Within a timespan of 4 weeks they can choose which day they’d like to join us. On their last day, they get a “good bye gift”. Unfortunatly this is easily forgotten. Since we run our reg...
I thought it worked perfectly until I found out that the formula is actually one month off… It’s telling me the right day but for some reason it’s a month ahead each time… I tried to give it a lazy solution by adding a DATEADD(… , -1 ‘mont...
Wow Julian… You’re an absolute genius for this one. It totally works!
I’m not totally new to airtable but this one was definitely out of my league. I never used the ROUNDUP or VALUE in a formula before. Thank you so much
I’m gonna try and see if I ca...