Hi Everyone, Very new to Airtable but I can’t find the answer here on how to solve my issue. (I’m sure I’m just doing something wrong)…
I’m trying to convert a mm measurement into a UK shoe size (293mm == UK Size 10)
I have a customer consultation table which takes in a mm value - I’d like it to lookup that input in a separate table and then return the UK Shoe size and add it to the consultation table (to save manually going back and forth).
One issue is also needing it to ‘round up’ the mm field (UK size 9.5 is 286mm so 287,288,289,290,291,292 & 293 are UK size 10)
Is there a way to do this?