Change the status field in more than one rows.

[lec]

Hi, 

I have a table BIC as below:

Datetime      Bank    Dated          Account        Amount    Status
2/22/2023      UBA     2/9/2023      1321742231       100           Opened        
2/22/2023      UBS     1/27/2023     7475174212      200           Opened
2/22/2023      UBA     1/17/2023     2369904112     300           Opened

I have created a bot/animation which generates a pdf file with rows of table, based on the condition that [Status] = Opened AND Today()-[Dated] > 1 

for simplicity. 

After the pdf has executed I wish to change all the [Status]=Opened values to Closed so that they don't interfere with the generation of the next PDF later at some point of time. 

For this I created an action 

status-closed action

Behavior has the formula :  AND([Status] = "Opened", TOTALHOURS(TODAY() - [Dated]) / 24 > 12)

This I tested and it changes successfully the values of the Status in the column that I select. So it works on one column. 

Then after the PDF is generated I created another task as below:

 

but this does not work. I know the value showing in Referenced rows is wrong and should be, i think,  

selecting the rows governed by the formula:

AND([Status] = "Opened", TOTALHOURS(TODAY() - [Dated]) / 24 > 12) but this gives an error

and I am unable to find the right way of referencing the rows that I wish to target. 

I'll be grateful for any help. Thanks.