Hello
we currently have a Smartsheet and Slack trigger where a new row created in a Smartsheet will send a message to a specific channel in Slack. The Smartsheet has 15 columns is there a way to have the Slack message text content only capture fields that have actual data input into the Smartsheet row.
+6
Hi there
Welcome to the Community! 🎉
I did some digging into this, and it seems like you may be able to achieve this by adding a Filter by Zapier step to your workflow, this way the Zap will only continue if there’s a data on your Smartsheet row.
You can learn more about Filter by Zapier here:
Hopefully, this points you to the right direction! 😊
Hi Ken
So i understand that part a new row with data will trigger the Zap. I am asking if we can have a field only display in the slack message text we send if the cell has data. Eg Column Heading “Direction” Cell data “North” OR Column Heading “Direction” Cell data “blank”
+6
Hi
Thank you for the clarification.
I did some digging and also tested it out myself, and it seems that there isn't a straightforward method to prevent sending the data if the row in your Smartsheet is empty. However, I have a workaround that you can give a try!
You can utilize the "Text in Formatter - Default Value" action. Within the "Default Value" field, you can input an underscore (_) or the word "Empty". This will enable you to display a specific value when the column is empty.
I hope this workaround proves helpful to you and guides you in the right direction!
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
