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

Options
✭✭✭✭

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.

## Best Answer

• ✭✭✭✭✭
Answer ✓
Options

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.

## Answers

• ✭✭✭✭✭
Answer ✓
Options

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.

• ✭✭✭✭
Options

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

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!