Setting up a trigger comparing today's entry with the last entry.
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
-
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
-
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.
-
AMAZING!!!! thank you so much!!!!!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 379 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 302 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!