You’ll find a couple of different options in the following thread:
You’ll find two main alternatives in that thread. One uses Glide computed columns, and the the other uses a Spreadsheet formula. Which is best for you depends on your use case - probably the Glide solution is better for you in this case.