How to use a conditional formula based on a lookup?
Hi, I need a formula that is something like this : if(Test = TRUE, if(Installer.toString() == "Patriot", 1000, 0), 1). However, Installer is a lookup field and zoho doesnt seem to be catching that. How can i make that work?