I can’t believe that I took so long to discover Airtable. But now that we have one another in each others lives, the rest is history.
Now, feature request; I just created a “frequency” - Single Select - column for when subscribed payments would occur, with the options Weekly, Fortnightly, Monthly, Annually.
Next to this column is a “Payment” currency column for the input of currency. And finally next to that is an “Annual Total” Formula column, where;
Annual Total = Payment * Frequency
That’s the moment when I realised, that I’ll need nested IF loops to get the job done, as Weekly = 52, Fortnightly = 26, Monthly = 12, Annually = 1… Yet this would be so much easier & neater if I could use a switch statement - Select Case.
It sure would be nice for the devs to include this.
IF(Frequency = "Weekly", Value*52,IF(Frequency = "Fortnightly", Value*26,IF(Frequency = "Monthly", Value*12,IF(Frequency = "Yearly", Value,0))))
Looks so ugly >_<