So Im pretty new to Airtable and not sure if I am going about this the right way and wonder if someone can point me in the right direction if not. Basically I am trying to use a multi select option to calculate the Extra costs involved in a job with solar installations which I have a field named Extras. So lets just say I have an option of installing on a tile roof which costs an extra 50 which I have added using the formulas below in a separate field called Extras Total.
IF(
FIND('Tile Roof', Extras),
50
) +
IF(
FIND('3 phase', Extras),
200
) +
IF(
FIND('Solar Hot Water Removal', Extras),
800
) +
IF(
FIND('Optimiser', Extras),
100
) +
IF(
FIND('Panel Removal', Extras),
20
)
Where I am having trouble is with panel removal and optimisers there may be more than 1 panel or optimiser so is there a way that I can add multiple amounts to these particular options. My only thought would be to add multi options for each one e.g 1 panel removal, 2 panel removal, 3 panel removal etc. But this way would make it messy and have so many options and also would make the above formula very long, is there any way to streamline this?
