Automation For Data Change via Date

[lstephens]

I need the data of one column to be changed depending the date. I am not sure why it is not working.

I have Time Cards with a [Status] column. When in the current week, [Status] reads “active”. At 12:01am, Monday morning (Day 1 of the next week) I have the pic’d automation scheduled to run.

The first process is to see if there are anymore time cards from last week that need Review/Approval before the timesheet is sent to the office. This process has the expression WEEKNUM([CLOCK IN])= WEEKNUM( (EOWEEK(TODAY()) - 7) +1).

The next process ‘Runs and action on Rows’ which sets “Active” status to “In Review” status.

The action looks like this

The reference rows look like this.

REF_ROWS(“Active Time Cards”,“Status”)

When I test it, it says the first process was successful but below is the message it says for the second process.

[WillowMobileSys]

This si an improper use of REF_ROWS. REF_ROWS() function MUST match the current row Key column to a Ref column in the target table. For instance, your implementation says “get all rows from Active Time Cards where the Status column value matches the Key Column value of the current row”. I’m pretty sure that’s not what you want.

Where are you using the REF_ROWS() expression and what are you trying to accomplish? You probably will need to use a SELECT() or FILTER() expression instead.

[lstephens]

Oh ok, yea, no I do not want them to match my key column.

I was using them here where it says referenced rows. What should be in this box?

I am trying to pull time cards from last week that the employee needs to review/approve. Then once approved copy the rows to another spreadsheet. But that’s not working either.