Hey Airtable Community,
I just want to sum app the numbers of the following column into one single row in a table:
So that I can use that result to transfer it to my Webflow CMS.
Please help :woozy_face:
We´re a learn platform with memberships. Each mempberships has its values in numbers.
I need to replace/substitute those values into another values.
This is what I want:
9=1
19=2
39=4
99=11
This is my formula:
SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTI...
Thank you so much for the fast reply and the given solution! :slightly_smiling_face:
I changed the origin column into numbers and took this formula:
SWITCH(
{FOX XP AMOUNT},
9, 1,
19, 2,
39, 4,
99, 11,
{FOX XP AMOUNT}
)
It worke...
