Hi @Matt5 ,
What Asana plan are you using? If you’re a Business or Enterprise customer maybe you find some answers under these topics: Introducing Formula Custom Fields! and Formula custom field with Advanced Editor
I’m not completely sure if a Formula Custom Field can be set up to your requirements… but it’s possible! I am a Premium user so I cannot make any experiments.
Hope the links I sent will help!
Elina.