SharePoint List Calculated Column Multiselect Point Addition

%3CLINGO-SUB%20id%3D%22lingo-sub-3319558%22%20slang%3D%22en-US%22%3ESharePoint%20List%20Calculated%20Column%20Multiselect%20Point%20Addition%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3319558%22%20slang%3D%22en-US%22%3E%3CP%3ELets%20say%20the%20choice%20column%20was%20multiselect%2C%20meaning%20you%20could%20select%20multiple%20options.%20How%20would%20I%20go%20about%20adding%20the%20points%20up%20on%20the%20second%20column%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBelow%20is%20my%20example%20and%20error%20I'm%20getting%3A%26nbsp%3B%3C%2FP%3E%3CP%3E(I%20have%20three%20selectable%20options%20and%20gave%20them%20all%202%20points%20each%20for%20a%20total%20of%206%20points.%20Lets%20say%20I%20were%20to%20select%20%22Multiple%20Users%22%20and%20%2220%20Users%2C%22%20that%20should%20equal%20up%20to%204%20points.%20If%20I%20selected%20all%20three%20options%20from%20the%20drop%20down%20menu%2C%20it%20would%20be%206%20points.%20So%20I%20have%20two%20columns%20related%20to%20this.%20First%20column%20is%20%22Collaboration%22%20and%20second%20column%20is%20%22CollaborationCalculated%22%20which%20is%20a%20Calculated%20Field.%20When%20I%20add%20this%20formula%20below%20in%20the%20%22CollaborationCalculated%22%20column%20it%20works%20until%20I%20make%20the%20%22Collaboration%22%20column%20to%20Allow%20multiple%20selections.%20I%20get%20the%20below%20error%20which%20says%3A%20%22unsupportedFieldTypeError.%22%20Is%20there%20an%20IF%20statement%20with%20addition%20involved%20to%20make%20this%20work%3F)%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DIF(%5BCollaboration%5D%3D%22Multiple%20Users%22%2C2%2C%3C%2FP%3E%3CP%3EIF(%5BCollaboration%5D%3D%2220%20Users%22%2C2%2C%3C%2FP%3E%3CP%3EIF(%5BCollaboration%5D%3D%2210%20Users%22%2C2%2C%22%22)))%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22SyedFaizuddin_0-1651726033643.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F369358i0FB6FF5BBAAFA856%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22SyedFaizuddin_0-1651726033643.png%22%20alt%3D%22SyedFaizuddin_0-1651726033643.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22SyedFaizuddin_1-1651726129980.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F369359i135F0D5AFE68BAC4%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22SyedFaizuddin_1-1651726129980.png%22%20alt%3D%22SyedFaizuddin_1-1651726129980.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3319558%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMicrosoft%20Lists%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3322225%22%20slang%3D%22en-US%22%3ERe%3A%20SharePoint%20List%20Calculated%20Column%20Multiselect%20Point%20Addition%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3322225%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1381529%22%20target%3D%22_blank%22%3E%40SyedFaizuddin%3C%2FA%3E%26nbsp%3BSharePoint%20doesn't%20suppport%20referencing%20a%20multi-choice%20column%20in%20a%20calculated%20column%20formula.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3CBR%20%2F%3E%3CFONT%20size%3D%222%22%20color%3D%22%23006400%22%3EIntranet%2C%20SharePoint%20and%20Power%20Platform%20Manager%20(and%20classic%201967%20Morris%20Traveller%20driver)%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Lets say the choice column was multiselect, meaning you could select multiple options. How would I go about adding the points up on the second column? 

 

Below is my example and error I'm getting: 

(I have three selectable options and gave them all 2 points each for a total of 6 points. Lets say I were to select "Multiple Users" and "20 Users," that should equal up to 4 points. If I selected all three options from the drop down menu, it would be 6 points. So I have two columns related to this. First column is "Collaboration" and second column is "CollaborationCalculated" which is a Calculated Field. When I add this formula below in the "CollaborationCalculated" column it works until I make the "Collaboration" column to Allow multiple selections. I get the below error which says: "unsupportedFieldTypeError." Is there an IF statement with addition involved to make this work?) 

 

=IF([Collaboration]="Multiple Users",2,

IF([Collaboration]="20 Users",2,

IF([Collaboration]="10 Users",2,"")))

 

 

SyedFaizuddin_0-1651726033643.png

SyedFaizuddin_1-1651726129980.png

 

 

1 Reply

@SyedFaizuddin SharePoint doesn't suppport referencing a multi-choice column in a calculated column formula. 

 

Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)