Formula Help

Tzippy

I have a dropdown column and I need to automatically populate different numbers in another column based on what's selected.

Column one:

HHA

PCA

Column two:

if hha is selected, i want the number 12 to populate

Paul Newcome

You would use somethign like this:

=IF([Column One]@row = "HHA", 12)

Paul Newcome

You would use somethign like this:

=IF([Column One]@row = "HHA", 12)

Tzippy

Got it! Thank you Paul!

Paul Newcome

Happy to help. 👍️