More #UNPARSEABLE problems

IanW

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

% 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

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. 

• https://help.smartsheet.com/learning-track/get-started/formula-basics#tips