Select a Value in Dropdown Cell Using IF Formula

I want the LabWare User Status cell value to be Pending if the checkbox in the Request LabWare Account cell is Checked. I've tried IF ([Request LabWare Account]@row = "Checked", "Pending") and a few other formula variations inside the LabWare User Status cell but it looks like formula's cannot be used to select or apply a value in a dropdown cell. Am I wrong? Please help. 😓

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!