0

Trying to either use FLOW or calculated column in sharepoint to try and achieve the following. Appreciate anyones help on this.

God Bless Janan

enter image description here

Janan Lim
  • 1

1 Answers1

0

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:

enter image description here

SharePoint Calculated Conditional formulas
SharePoint 2013 calculated column adding multiple if statement

Updated:

Flow step: enter image description here

1

enter image description here

2

enter image description here

3

enter image description here

4

enter image description here

Amos
  • 1,981
  • 1
  • 6
  • 12
  • 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 – Janan Lim Dec 16 '20 at 04:18
  • Do you want to count each occurrence of the values column?Or something else？ – Amos Dec 16 '20 at 05:42
  • yes. Would like to count each occurrence of the values column – Janan Lim Dec 16 '20 at 06: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. – Amos Dec 17 '20 at 09:24