Forum Discussion
Calculated Column with comma
Hi,
I have two Columns with numbers separated by commas in a Sharepoint List. I want the result to be calculated in a new column:
So the result should be calculated used this logic:
(10*10) + (2*5) + (6*3)
Now there can be many comma separated values but values in Values col and Stock col will always have the same number of commas. So the formula should be smart enough to count number of commas and multiple value in right order.
Any help is much appreciated. I am new to Sharepoint List so please try to break it down.
Thanks a lot in advance.
2 Replies
Manoj It would be much easier if you just had 6 columns for the 10 2 6 10 5 3 and then the Result calculated column would be very simple. If you really need the Values and Stock columns in the format they are then use a concatenate formula for those columns but base the actual calculation on the other 6 columns.
If for some very bizarre reason that is not possible then it would need a solution in Power Automate using the split function.
Rob
Los Gallardos
Microsoft Power Automate Community Super UserRobElliottthanks for your response.
Requirement is such that the user needs to add data in this format. 6 cols won't work as the number of commas are not fixed.
Do you have any link that shows how to use split in Power Automate?
Thanks
