Write a formula in a cell - Excel

Help Activities
, ,
1

Hi,

I need to write a formula in a for each row activity. The formula is : “=text(‘C’+Counter.tostring,‘dd.MM.yyyy’)”.

It’s troughing an error:

image
image711×409 77.1 KB

Anyone knows how should I write this?

Best regards,
Paul

2

Hi @paul.baltag1 ,

What type of activity you are using?
If that excel file is open status please close and try it.
For example in cell A1 I want to update formula, you can use workbook read range activity and “=Date()”

Regards,
Pavan Kumar

3

@paul.baltag1

Please try like this

"=text(C1,""dd.MM.yyyy"")" and then you can use auto fill range to fill the formula in all rows

If still need to do in loop only then

"=text(C" + counter.ToString +",""dd.MM.yyyy"")"

Cheers

4

Thank you very much , it’s working with autofill.

1 Like
5

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.