SOLVED

How to Edit a Calculated Column & IF Statement Limits?

%3CLINGO-SUB%20id%3D%22lingo-sub-849416%22%20slang%3D%22en-US%22%3EHow%20to%20Edit%20a%20Calculated%20Column%20%26amp%3B%20IF%20Statement%20Limits%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-849416%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20calculated%20column%20which%20uses%20the%20following%20formula%26nbsp%3B%3CBR%20%2F%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DIF(%5B_UpdatedSupplierFinancialRiskRating%20%5D%3D%22High%22%2C15%2CIF(%5B_UpdatedSupplierFinancialRiskRating%20%5D%3D%22Medium%22%2C7%2C0))%3CBR%20%2F%3E%3CBR%20%2F%3EI%20was%20having%20trouble%20getting%20it%20to%20work%20so%20I%20set%20it%20up%20with%20this%20to%20make%20sure%20my%20syntax%20was%20correct.%20I%20want%20the%20column%20to%20have%20the%20following%20formula%20but%20how%20do%20I%20get%20into%20edit%20it%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DIF(%5B_UpdatedSupplierFinancialRiskRating%20%5D%3D%22High%22%2C15%2CIF(%5B_UpdatedSupplierFinancialRiskRating%20%5D%3D%22Medium%22%2C7%2C0))%2BIF(%5B_UpdatedSupplyAvailability%5D%3D%22High%22%2C25%2CIF(%5B_UpdatedSupplyAvailability%5D%3D%22Medium%22%2C14%2C0))%2BIF(%5B_UpdatedEndOfLifeRating%5D%3D%22High%22%2C15%2CIF(%5B_UpdatedEndOfLifeRating%5D%3D%22Medium%22%2C7%2C0))%2BIF(%5B_UpdatedEaseOfTransfer%5D%3D%22High%22%2C25%2CIF(%5B_UpdatedEaseOfTransfer%5D%3D%22Medium%22%2C14%2C0))%2BIF(%5B_UpdatedCustomerConcentration%5D%3D%22High%22%2C10%2CIF(%5B_UpdatedCustomerConcentration%5D%3D%22Medium%22%2C4%2C0))%2BIF(%5B_UpdatedLeadTime%5D%3D%22High%22%2C10%2CIF(%5B_UpdatedLeadTime%5D%3D%22Medium%22%2C4%2C0))%3CBR%20%2F%3E%3CBR%20%2F%3EIn%20column%20settings%20there%20is%20no%20edit%20option%2C%20nor%20is%20there%20remove%20or%20I%20would%20just%20delete%20it%20and%20start%20over.%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3EAlso%20is%20there%20a%20limit%20on%20the%20number%20of%20IF%20Statements%20I%20can%20use%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-849416%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-849632%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20Edit%20a%20Calculated%20Column%20%26amp%3B%20IF%20Statement%20Limits%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-849632%22%20slang%3D%22en-US%22%3E%3CP%3EI%20was%20able%20to%20find%20the%20answer%20in%20this%20video%3A%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3Dic9Je9AlAf4%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3Dic9Je9AlAf4%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3EI%20had%20to%20convert%20to%20the%20old%20format%20through%20to%20see%20this%20list%20settings.%20But%20it%20worked%20and%20that%20is%20all%20that%20matters%20right%20now.%20Did%20all%20of%20this%20functionality%20go%20away%20with%20the%20new%20look%3F%20I%20suspect%20not%20but%20I%20can't%20seem%20to%20find%20it.%20Needless%20to%20say%20I%20will%20be%20using%20the%20old%20look%20from%20now%20on.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

I have a calculated column which uses the following formula 
 

=IF([_UpdatedSupplierFinancialRiskRating ]="High",15,IF([_UpdatedSupplierFinancialRiskRating ]="Medium",7,0))

I was having trouble getting it to work so I set it up with this to make sure my syntax was correct. I want the column to have the following formula but how do I get into edit it? 

 

=IF([_UpdatedSupplierFinancialRiskRating ]="High",15,IF([_UpdatedSupplierFinancialRiskRating ]="Medium",7,0))+IF([_UpdatedSupplyAvailability]="High",25,IF([_UpdatedSupplyAvailability]="Medium",14,0))+IF([_UpdatedEndOfLifeRating]="High",15,IF([_UpdatedEndOfLifeRating]="Medium",7,0))+IF([_UpdatedEaseOfTransfer]="High",25,IF([_UpdatedEaseOfTransfer]="Medium",14,0))+IF([_UpdatedCustomerConcentration]="High",10,IF([_UpdatedCustomerConcentration]="Medium",4,0))+IF([_UpdatedLeadTime]="High",10,IF([_UpdatedLeadTime]="Medium",4,0))

In column settings there is no edit option, nor is there remove or I would just delete it and start over. 

Also is there a limit on the number of IF Statements I can use? 

1 Reply
Highlighted
Best Response confirmed by kaleyanne (New Contributor)
Solution

I was able to find the answer in this video: 

https://www.youtube.com/watch?v=ic9Je9AlAf4

I had to convert to the old format through to see this list settings. But it worked and that is all that matters right now. Did all of this functionality go away with the new look? I suspect not but I can't seem to find it. Needless to say I will be using the old look from now on. 

 

Thanks!

Enjoy the videos and music you love, upload original content, and share it all with friends, family, and the world on YouTube.