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.
Email : thinh.huynh@giathinh.tech
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.7K Get Help
- 436 Global Discussions
- 152 Industry Talk
- 497 Announcements
- 5.3K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 77 Community Job Board
- 508 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 308 Events
- 37 Webinars
- 7.3K Forum Archives