Hi @Derek_Hendrock , it sounds like you are on the Business plan, thus have access to formula fields and the recently launched advanced editor so I think I have just the ‘workaround’ you need!
Have a look a this post and let me know if that works for you: