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:
