Add auto increment number in Excel template

[Firdaus_AG]

Hi everyone,

I create a Task to Email and attach a file in XLSX format. In Excel, I need to insert a numbering starting from number 1 for each row. Please help me to give me an idea how to fix this. Thank you.

@fteam

[SkrOYC]

https://www.googlecloudcommunity.com/gc/Tips-Tricks/INDEXOF/m-p/427993/highlight/true#M6434

[Firdaus_AG]

I don't really get it. Here I show you the formula that I wrote in Excel.

This is the formula in my Excel is

Number	Name	Matrix Number	Gender	Class
<<Start: SELECT(ePPC[ID], [_THISROW].[Email] = [LEmail], FALSE)>>	<<[Name]>>	<<[Matrix Number]>>	<<[Gender]>>	<<[Class]>><<End>>

The result after I run the task:

Number	Name	Matrix Number	Gender	Class
	Student 1	123	Male	Class 1
	Student 2	125	Female	Class 4
	Student 3	122	Male	Class 5
	Student 4	111	Male	Class 1
	Student 5	433	Female	Class 1

The result that I want should be like this:

Number	Name	Matrix Number	Gender	Class
1	Student 1	123	Male	Class 1
2	Student 2	125	Female	Class 4
3	Student 3	122	Male	Class 5
4	Student 4	111	Male	Class 1
5	Student 5	433	Female	Class 1

[SkrOYC]

I know, that's why I send you the workaround. There is no official method, unless Excel provides something like a rownumer function

[Firdaus_AG]

It works when I insert the excel formula ROW($B2)-ROW()+1 between the <<Start:>><<End>>

[gregdiana1]

row() - 1 should also work.

SEQUENCE(count([NAME])) might work as it will create a sequence 1,2........N where N is the count of NAME

[SkrOYC]

---

@SkrOYC wrote:

unless Excel provides something like a rownumer function

---

There you have it