Hi there - I’m looking to set up a formula to determine fiscal year and can’t figure it out. Help appreciated
I tried setting up an IF function (i.e., if the date in the “Engagement End Date” column is on or after 7/1/2018, then the fiscal year is 2019, and if the date in the “Engagement End Date” is on or after 7/1/2019, then fiscal year is 2020.)
Also - is there a formula in Airtable comparable to IFERROR? I don’t quite think ERROR and ISERROR formulas are what I’m looking for. Thanks!