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 ...
Hi everybody,
I got 7 fields that are either empty OR contains a name… Is there a formula which sums up how many of these 7 fields contains a name (and aren’t empyt)?
Thanks in advance!
Hi everybody
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...
Hi everybody.
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...
Hi Julian,
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...
Thanks for the fast reply.
I think I already did it myself by adding: DATEADD({Created_time}, -1, ‘days’)
I really wonder what you thought would also work tho :slightly_smiling_face:
Gr.
