Hello, I want to type this formula on a column and I use write cell activity (excel activities). This is the formula =TEXT(I2,“YYYYMMDD”) , but I have problem with the quotes. I can’t write “=TEXT(I2,“YYYYMMDD”)” also I need to increment the formula at each row. I mean, in the next row to be =TEXT…

Hi, Please input same as my sample. [image] Regards,

Type an excel formula and increment it

Yoichi (Yoichi) December 20, 2022, 8:13am 5

Hi,

We can use currentIndex variable in ForEachExcelRow as the following.

Can you try this?

Regards,

Topic		Replies	Views
Write a formula in a cell - Excel Activities excel , activities , question	4	520	January 26, 2023
Write Excel formul using Write Cell Activity Activities excel , activities , question	7	946	January 8, 2022
Write Cell activity in StudioX: Auto Increment Row not working in Excel file StudioX studiox , question	7	2335	March 16, 2022
Increment Text formula in 'what to write' in Write Cell function StudioX studiox , question	6	1972	March 25, 2021
How to autoincrement cell index in Excel formula for Write Cell Forum excel , question	4	1240	October 23, 2022