Trying to either use FLOW or calculated column in sharepoint to try and achieve the following. Appreciate anyones help on this.
God Bless Janan
1 Answer
Try this:
=IF(Values="AA","3",IF(Values="BB","4",IF(Values="CC","1",IF(Values="DD","5",IF(Values="FF","2",IF(Values="WW","6",IF(Values="HH","7","NONE")))))))
Test result:
SharePoint Calculated Conditional formulas
SharePoint 2013 calculated column adding multiple if statement
Updated:
Flow step:
1
2
3
4
-
Thank you for the above. However, I am not trying to assign a unique value for each item. I would like to count everytime a unique value appears. And the unique value is not limited to this 7, it could expand anytime Commented Dec 16, 2020 at 4:18
-
Do you want to count each occurrence of the values column?Or something else？– AmosCommented Dec 16, 2020 at 5:42
-
yes. Would like to count each occurrence of the values column Commented Dec 16, 2020 at 6:15
-
That may only be achieved with flow, use rest to get the number of items with the same value, and then update the current item.Check my update.– AmosCommented Dec 17, 2020 at 9:24