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

Activity
image

output (FIRST ROW)

output (LAST ROW)
image

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

image

1 Like

IT WORKED!!! thank you so much.