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
AI Accelerator
Airtable Enterprise Network
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
May 21, 2024
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