Hi,
First: Airtable is an incredibly useful program, both for business and personal use. It’s a lifesaver that I’ve been using for years.
However … I have need for Formulas for the first time and having trouble getting my head around the syntax for this task.
I need to conditionally add and output the sum of 3 Currency fields based on the status of the Checkboxes:
IF the status of {$VALUE 1} is checked - output of the Formula field is $VALUE 01. Otherwise the output of the Formula field is 0.
IF the status of {$VALUE 1} and {$VALUE 2} are checked - output of the Formula field is ($VALUE 01 + $VALUE 2). Otherwise the output of the Formula field remains $VALUE 1.
IF the status of {$VALUE 1} and {$VALUE 2} and {$VALUE 3} are checked - output of the Formula field is ($VALUE 01 + $VALUE 2 + $VALUE 3). Otherwise the output of the Formula field remains $VALUE 1 + $VALUE 2).
For this task the $VALUES will either be hit in sequence, or they won’t. ie: We will never have a case where we need to add and output $VALUE 01 + $VALUE 03 for instance.
I have some of the pieces of the puzzle but not nearly qualified to put them together yet. Any wizards out there feel like taking a crack at this or throwing me some clues? Mucho gracias
t2: