Static date column after adding new row

Help Studio
, , , ,
1

Hi all,

I have a question about making a column static after the first time it’s added to a sheet.
For example I am retrieving emails based on a pending category. I have a column for the current date and a column for the date that the email started pending which also starts at the current date. (4/4/2024 And 4/4/2024). But If the bot runs the next day and that email is still pending then the current date will be 4/5/2024 and started pending date should still be 4/4/2024 aka static. I need this to keep track of days pending for the email. I cannot use received time because an email does not get categorized right away. So basically the started pending column should get the date once and stay static forever. I have tried If conditions but no luck.

2

Is the pending date and current date explicitly specified in the use case?
If so, have you tried conditioning the process not to write to a cell when it already contains a value?

3

Hi Emmanuel I have tried different ways to only write a date in a new row and not old rows but I haven’t had any success.

4

Oh okay, so if I’m getting you clearly:
Each email has their own pending date that may or may not be different from the current date and you want to write this pending date to each email’s row in the pending column and keep it that way?

5

@srobey888 Can you share a screen shot of input and output excel file or the dummy excel?

6

Correct. The start of the pending date should never change, but the current date should keep up for each day

7

absolutely.

12

This first screenshot shows the pending date and the current date.

13

And this screenshot is what I would like to happen. The pending date remains the same after another bot run but the current dates updates accordingly.

8

@srobey888,

You should be using Excel Application Scope and write cell with formula to put current date like =Today()

For Days Pending also you should be writing formula to count.

This way the Days Pending and Current Date will be dynamic.

Thanks,
Ashok :slight_smile: