Function for Status based off 2 stages of approval

HardWork

Kelly Moore

Hey @HardWork

Let's try this

=IF([Stage 2]@row="Approved", "Green", IF([Stage 1]@row="Denied", "Yellow", "Red"))

Does this get you what you need? We can tweak this if needed

Kelly

Kelly Moore

Hey @HardWork

Let's try this

=IF([Stage 2]@row="Approved", "Green", IF([Stage 1]@row="Denied", "Yellow", "Red"))

Does this get you what you need? We can tweak this if needed

Kelly

HardWork

You are amazing!!! Thank you!!