3 Row Limit for workflow notification to slack
Jared Meyer
✭✭
I've set up an automation to send a slack notification when a date is reached on a sheet. Typically there are only 2-3 rows that trigger this on a daily basis.
However when more than 3 are triggered, the slack notification only shows the first 3 rows and then indicates there is 1 other row but no further info. Is there a way to ensure more rows are shown in the slack notification?
Answers
-
Hi Jared Meyer,
I got this idea :
Create 2 new helper columns : "RowID" (auto-number) and "Count" as below screenshot
The "Count" column has the column formula as below:
=IFERROR(MATCH(RowID@row, COLLECT(RowID:RowID, [Appointment Time - MT]:[Appointment Time - MT], @cell <> ""), 0), "")
Modify your worflow, add more "Count" checking condition as below:
Hope it works for you.
Gia Thinh Technology - Smartsheet Solution Partner.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives