Ilan_Ben_Yaakov - profile

Ilan_Ben_Yaakov · 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') )

Ilan_Ben_Yaakov · Dec 18, 2022

hi,It should look like IF(subscription="yearly",DATEADD(NOW(),1,"year"),DATEADD(NOW(),1,"month"))

Ilan_Ben_Yaakov · Aug 25, 2022

that should work: IF( AND( {condition 1}="Complete", {condition 2}="Complete", {condition 3}="Complete", {condition 4}="Complete"), "YES" )

Ilan_Ben_Yaakov · Dec 27, 2021

you should use the function RECORDID(): IF(RECORDID(Choice)="selQHcj58xhh44C1J","blah","")

Ilan_Ben_Yaakov · Jul 11, 2021

try DATETIME_DIFF(start time,end time,'days')

User Statistics

User Activity

Re: Update due date based on IF formula

Re: Update due date based on IF formula

Re: Complex Formula Question

Re: [Formula] use option IDs instead of values for single/multiple select fields

Re: AirTable World - Need a formula that calculates or date / hr / min difference - Start date / time - end date / time