Question

Only trigger specific Smartsheet cells

  • 13 May 2022
  • 1 reply
  • 6 views

I need HELP!  I have a Smartsheet to Outlook integration set up. Draft email is created when a row in smartsheet is updated. So far this is great, but I have over 200 columns in smartsheet and I do not want any of the 200 cells in one row to be the actual trigger. I know there is a filter option and i can specify a cell in smartsheet. The problem is even though I set up “if there is a date in a particular cell” (lets call it column A) to be the trigger….2 weeks later when  i am updating one of the other 200 cells (lets call it column z) in the same row, it will still look for Column A to be true and create a another email. 

 

I would like for zapier to see the trigger only once and act on it. Like keep it within a few column like Column A through column D. Hope this makes sense. 


1 reply

Userlevel 7
Badge +13

Hi @BatmanVCA 

Good question.

This can be solved by using these Zap steps…

  1. Trigger: Smartsheet - Updated Row
  2. Action: Filter
    1. Filter for rows that have not yet been processed as indicated by a new column
      1. See Step 4
  3. Action: Outlook - Create Draft Email
  4. Action: Smartsheet - New Row Update
    1. Update a new column to indicate this row has been processed

Reply