For Each excel Row

I need help and I hope someone can provide me with a solution. I’m attempting to calculate between two dates. I placed the formula in the “what to write” field and need it to paste it to all the rows under the column “Days”. When I run the activity it copies the same formula for each row. That is not the output I’m looking for. Am I suppose to use the currentindex, and if so how do I write it in the Advanced Editor? Any help will be greatly appreciated.

before output


output (FIRST ROW)

output (LAST ROW)

sla metrics report.xlsx (17.3 KB)

Better option than using Current Index is using AutoFill (same as in Excel):

  1. Write the formula in the first row
  2. AutoFill


1 Like

IT WORKED!!! thank you so much.