This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
I am trying to create a scoring system for this table. For example IF my Status is “Interested” then Field 18 equals 5. IF Status equals “Sent High Level” then Field 18 equals 2…IF Status equals “NO - PASS” then Field 18 equals 0.
Justin_Barrett:
IF({Status}=“NO - PASS”,0, IF({Status}=“Sent High Level”,2, IF({Status}=“Interested”,5)))
Wow! Thanks for the quick reply! Damn you extra space :slightly_smiling_face: