I am new to Airtable and struggling to get proper syntax in a column
So I want to create a column called Key Date, and make a formula that instructs it
if the Column “Category” = “People” then display the year from the column “Year” and add 30 years. if Category ≠ People, leave blank.
I am used to the If,Then, Else logic of Excel but couldn’t get it to work in AirTable,
I tried: if(Category=People),(Year+30),("")
can anyone tell me why airtable is rejecting my syntax? Thanks a bunch!!!