THANK YOU!!!!I did some testing (took me a little longer not knowing code syntax) but think it worked!  Appreciated and posting samples below for others as reference Sample of the code on the calculated field on the form (Phase is the original custom field)IF({DE:Phase}="SOW","10",IF({DE:Phase} = "D...

Hopefully someone has done this and has some text mode samples to share to accomplish. I have a custom field on a form where the values are from a custom list.  We entered the list values on the field in the order the user should see them.  As a result, not in alpha order. How can I have a report so...