Nested "IF" statements
I'm trying to stay away from code and just use the native functionality of QB for a sales CRM. I may be stuck. Here's what I have: If( [Stage]="Lead",0.1, [Stage]="Gained Access",0.2, [Stage]=...
Forum Discussion
Hi Michael,
If I'm understanding correctly, you'd be able to accomplish this with a combination of an added numeric field and some conditional formatting in your form.
For example, you'd create a numeric field called "Proposed Confidence Level" that would only appear in your form "If [Stage] = "Proposed." Then, you'd update your If statement above to have [Stage]="Proposed",[Proposed Confidence Level].
Best,
------------------------------
Chris Wheatley
------------------------------
If I'm understanding correctly, you'd be able to accomplish this with a combination of an added numeric field and some conditional formatting in your form.
For example, you'd create a numeric field called "Proposed Confidence Level" that would only appear in your form "If [Stage] = "Proposed." Then, you'd update your If statement above to have [Stage]="Proposed",[Proposed Confidence Level].
Best,
------------------------------
Chris Wheatley
------------------------------