- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jul 12, 2024 11:50 PM
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.
Solved! Go to Solution.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jul 13, 2024 12:56 AM
Hmm, maybe use a new field called "# of Panels Removed" or something, and have the formula use that?
IF(
FIND('Tile Roof', Extras),
50
) +
IF(
FIND('Panel Removal', Extras),
{# of Panels Removed} * 20
)
 
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jul 13, 2024 12:56 AM
Hmm, maybe use a new field called "# of Panels Removed" or something, and have the formula use that?
IF(
FIND('Tile Roof', Extras),
50
) +
IF(
FIND('Panel Removal', Extras),
{# of Panels Removed} * 20
)
 
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jul 13, 2024 02:52 AM
Yeah I think this is a good solution, thank you!
