SOLVED
Home

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
kaleyanne
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
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!

Related Conversations
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies