
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jun 09, 2023 07:36 AM - edited ‎Jun 09, 2023 07:38 AM
Trying to accomplish this simple formula but it results in an error???
Using a Single Select Field and a Currency Field.
 Thanks in advanced for your assistance!
Solved! Go to Solution.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jun 09, 2023 09:16 AM
You need to convert the single select to a numeric value. I believe (Value(Toe Kick LI)) * (Toe Kick Cost Per LI) should work.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jun 09, 2023 09:16 AM
You need to convert the single select to a numeric value. I believe (Value(Toe Kick LI)) * (Toe Kick Cost Per LI) should work.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jun 09, 2023 10:30 AM
@BillH is right. Airtable sees single select options as objects containing text in this case and is having trouble inferring that this text should be converted to a number when multiplied/divided (it works fine with + or -). IMO this is a bug (great catch!).
This formula will work:
VALUE({Toe Kick LI}) * {Toe Kick Cost Per LI}

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jun 12, 2023 06:23 AM
Perfect! Thank you!
