Convert mm into UK shoe sizes and return value

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?

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.