You’re offline. This is a read only version of the page.
Announcements
I have a formula in Excel that I want to use as calculated value in sharepoint lists.
The cell in Excel is shown below
It is simply adding 5 characters ID (use first letter of Category, zeros, and not repeated count) with formula:
C2=CONCATENATE(LEFT(B2,1),IF(COUNTIF($B$2:B2,B2)<10,"000",IF(COUNTIF($B$2:B2,B2)<100,"00","0")),COUNTIF($B$2:B2,B2))
C3=CONCATENATE(LEFT(B3,1),IF(COUNTIF($B$2:B3,B3)<10,"000",IF(COUNTIF($B$2:B3,B3)<100,"00","0"));COUNTIF($B$2:B3,B3)) and so on across the column C.
If I want to use it on my Sharepoint lists, I realize that Lists cannot use COUNTIF and the fields are operated on their own row. Any idea using Flow that will result exactly same as the Excel formula?
Thanks.
Share
Report
All responses (
Answers (
375
