More #UNPARSEABLE problems

edited 12/09/19 in Smartsheet Basics

Hi all

I have no idea why this is not working.  Here is the formula that I am trying:

=if([Opportunity Stage]1="Lead - Qualified",5%,if([Opportunity Stage]1="Scoping Requirements",10%,if([Opportunity Stage]1="Proposal/Quote/RFP Presented",25%,if([Opportunity Stage]1="Contract - Legal Review",40%,if([Opportunity Stage]1="Contract - Comments Received",60%,if([Opportunity Stage]1="Contract - Final Negotiation",75%,if([Opportunity Stage]1="Contract - Executable Sent",95%,0)))))))

I have tried changing this to just 1 if statement - =if([Opportunity Stage]1="Lead - Qualified",5%,0%) and I still get #UNPARSEABLE.

So frustrating!  Any help... ?



  • Nic Larsen
    Nic Larsen ✭✭✭✭✭✭

    % in formulas need to be .75 or .1 without the %. Just format your column for %. If i update the numbers this works. I also added the @row:


    =IF([Opportunity Stage]@row= "Lead - Qualified", 0.05, IF([Opportunity Stage]@row= "Scoping Requirements", 0.1, IF([Opportunity Stage]@row= "Proposal/Quote/RFP Presented", 0.25, IF([Opportunity Stage]@row= "Contract - Legal Review", 0.4, IF([Opportunity Stage]@row= "Contract - Comments Received", 0.6, IF([Opportunity Stage]@row= "Contract - Final Negotiation", 0.75, IF([Opportunity Stage]@row= "Contract - Executable Sent", 0.95, 0)))))))

  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭

    Nic is correct. Percentages in formulas should always be set or called with decimals.

    .25 = 25%

    .5 = 50%

    .75 = 75%

    1 = 100% 

    There isn't much out there on this topic. But you can read some basic tips for working with formulas which includes this topic of percentages.