Having issues creating a NESTED IF formula. Please help!

Below is the formula. What I am trying accomplish is checking to see if a decmial field has a value above 0 and a check for the option set value. If it equals true I want it to set guid, if false set guid. I am trying to mimick this 11 times with in this formula, however it is not working. Please help.

 

IF(AND(new_timeentry.new_billablehours > 0 , new_timeentry.new_category_displayname = "Design"), "GUID", "GUID", IF(AND(new_timeentry.new_billablehours > 0, new_timeentry.new_category_displayname = "Development"), "GUID", "GUID"))

(13) Answers

Login