Formula to set RYG Status from a Cell with a drop down list?

I have a PO Status Column that I want to display a Red, Green, Or Yellow ball dependent on a selected drop down list in separate column titles Procurement Status. The formula Im using is below but it keeps returning "Unparseable".

=IF([Procurement Status]@row="Awarded", Green) IF([Procurement Status]@row="In Quote", Yellow) IF([Procurement Status]@row="Material Request Needed", Red)


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!