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
- Smartsheet Customer Resources
- 64K Get Help
- 410 Global Discussions
- 220 Industry Talk
- 459 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 137 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives