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. 😓
Help Article Resources
Check out the Formula Handbook template!