How do i do timestamp for specific columns

Hi guys, im not sure and figuring out how do i do the timestamps (Email sent column) for only the approved columns? Because currently im only able to do it for the whole column instead of the only approved ones. To keep things clear i dont want the timestamp for rejected.

Pictures for reference

You need to move the Excel Application Scope out of For Each Current Row as you don’t need to write result to file in the loop. Try it and then see whether it works.

Cannot need the excel file if dont have will have error

Also that one is not the problem is the range to write the value which i dont know how to only do it for the approved one


Hope the below steps would help you resolve this

  1. Use a excel application scope and pass the excel file path as input

  2. Inside the scope use a READ RANGE activity and mention the range as “A3” and enable Add headers property and het the output as dt

  3. Now use a FOR EACH ROW activity and pass dt as input

  4. Inside the loop use a IF condition like this


If true goes to THEN block where use a assign activity like this

CurrentRow(“Email sent”) = Datetime.Now.ToString

This is the important steps till where you almost reached

  1. then outside the FOR EACH ROW activity use a Write range activity and pass dt as input and enable Add headers property and mention range as “A3”

  2. This will write the output as expected


Your “if condition” is used correctly.

You can use Write Range activity (under System workbook) to update datatable instead of updating cell. Excel Application Scope is not needed for Read/Write Range under System Workbook.

Write Range activity should be inserted outside of For Each Current Row.

Thanks this works!!

1 Like

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