Skip to main content

How to multiply comma separated value

  • January 27, 2020
  • 1 reply
  • 11 views


Is it possible in airtable?

This topic has been closed for replies.

1 reply

Forum|alt.badge.img+19
  • Inspiring
  • January 27, 2020

This is possible, but only if you know for a fact that you will only have two values in each set.

Try this:

VALUE(LEFT({Field 1}, FIND(",", {Field 1}) - 1)) * VALUE(LEFT({Field 2}, FIND(",", {Field 2}) - 1)) & "," & VALUE(RIGHT({Field 1}, FIND(",", {Field 1}) + 1)) * VALUE(RIGHT({Field 2}, FIND(",", {Field 2}) + 1))