drop down and if fomular possible

Hi Experts,

I have enter this formal in my column

=IF(FIND("PRIME", [Sustainability and Ethics Compliance]@row) > 0, "pls select", "No need")

If"pls select" is the result, I would like that you are able to select other words from the pull down.

I have added in my pulldown :

pls select

No need

Yes

No

But in the column the pull down tap is not showing up. So I'm not able to select something new.

Is this normal, that I cannot combine a formula with a pull down?

Thanks

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!