The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.
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.