This website uses cookies. By clicking Accept, you consent to the use of cookies.
Click Here
to learn more about how we use cookies.
Accept
Reject
Support
Help Center
Airtable Universe
Airtable Templates
Airtable Guides
Developer Documentation
Sign up for Airtable
Airtable Community
Announcements
Discussions
Ask A Question
Show & Tell
Development & APIs
Groups
Marketing
Product Operations
Events
Resources
Getting Started
Job Board
Product Ideas
Search
Community
Knowledge base
Ilan_Ben_Yaakov
Users
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Search instead for
Did you mean:
Help
Sign In
Browse
Airtable Community
Ilan_Ben_Yaakov - profile
Ilan_Ben_Yaakov
6 - Interface Innovator
since
May 02, 2018
Dec 19, 2022
User Statistics
22
Posts
6
Solutions
14
Kudos given
11
Kudos received
View all badges
User Activity
Posts
Replies
No posts to display.
Re: Update due date based on IF formula
Dec 18, 2022
I assumed there could be only two options. you can also use the SWITCH formula like thisSWITCH( subscription, 'yearly',DATEADD(NOW(),1,'year'), 'monthly',DATEADD(NOW(),1,'month') )
Re: Update due date based on IF formula
Dec 18, 2022
hi,It should look like IF(subscription="yearly",DATEADD(NOW(),1,"year"),DATEADD(NOW(),1,"month"))
Re: Complex Formula Question
Aug 25, 2022
that should work: IF( AND( {condition 1}="Complete", {condition 2}="Complete", {condition 3}="Complete", {condition 4}="Complete"), "YES" )
Re: [Formula] use option IDs instead of values for single/multiple select fields
Dec 27, 2021
you should use the function RECORDID(): IF(RECORDID(Choice)="selQHcj58xhh44C1J","blah","")
Re: AirTable World - Need a formula that calculates or date / hr / min difference - Start date / time - end date / time
Jul 11, 2021
try DATETIME_DIFF(start time,end time,'days')
View more
Kudos from
User
Count
HaraldPalma
2
Mark_Comish
1
Maria
2
Justin_Barrett
1
Steven_Piasecki
1
View all
Kudos given to
User
Count
Andrey_Kovalev
1
HaraldPalma
2
Justin_Barrett
1
Mark_Comish
1
Maria
1
View all