AGM✭

If there is an opportunity to meet and discuss over a virtual platform, would be great. You could email me at[email protected]and I can send out an invite. Thanks!

Not having any luck with that one.

Thanks you... This worked! What if I needed to remove duplicates within the row?

Thanks!

Thanks you so much for your assistance. ️

Did we ever find a way to utilize this formula to add additional symbols?

I am trying to add a formula that will update my "Current Status" with the associated Color Ball based on the "Schedule Status" column. The formula that you provided is working. However, it does NOT account for multiple options. As I have four different color balls and five "Schedule State" options to coordinate. Current…

Thanks @Andrée Starå! What if the reference sheet is the same?