Setting up a trigger comparing today's entry with the last entry.

Elizabeth Aird

Operators will enter Paint Code, Line Speed and the Date is created at the time of entry. There are MANY paint codes.

How do I create a formula or workflow or BOTH to notify a manager WHEN the paint code has a lower line speed than the last time it was entered? Example below.

Christian Graf

Hello @Elizabeth Aird

Create a new column labeled "Previous Line Speed"

The following formula will give you the previously used line speed.

=IF(ISBLANK([Paint Code]@row) = 0, MIN(COLLECT([Line Speed]:[Line Speed], [Paint Code]:[Paint Code], =[Paint Code]@row, Date:Date, MATCH([Paint Code]@row, [Paint Code]:[Paint Code]) < Date@row)))

Once you have that, you can compare the two values in a Alert column. Make a new checkbox column labeled "Line Speed Alert". In the new column use the formula:

=IF([Previous Line Speed]@row >[Line Speed]@row, 1, 0)

Now create a new workflow that triggers when Line Speed Alert is checked.

You can create a contact column if you would like a specific contact emailed, or you can specify who to alert in the workflow.

Hope this helps.

Christian Graf

Hello @Elizabeth Aird

Create a new column labeled "Previous Line Speed"

The following formula will give you the previously used line speed.

=IF(ISBLANK([Paint Code]@row) = 0, MIN(COLLECT([Line Speed]:[Line Speed], [Paint Code]:[Paint Code], =[Paint Code]@row, Date:Date, MATCH([Paint Code]@row, [Paint Code]:[Paint Code]) < Date@row)))

Once you have that, you can compare the two values in a Alert column. Make a new checkbox column labeled "Line Speed Alert". In the new column use the formula:

=IF([Previous Line Speed]@row >[Line Speed]@row, 1, 0)

Now create a new workflow that triggers when Line Speed Alert is checked.

You can create a contact column if you would like a specific contact emailed, or you can specify who to alert in the workflow.

Hope this helps.

Elizabeth Aird

AMAZING!!!! thank you so much!!!!!