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

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

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
    – Janan Lim
    Dec 16 '20 at 4:18
  • Do you want to count each occurrence of the values column?Or something else?
    – Amos
    Dec 16 '20 at 5:42
  • yes. Would like to count each occurrence of the values column
    – Janan Lim
    Dec 16 '20 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.
    – Amos
    Dec 17 '20 at 9:24

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.