Skip to main content
Best answer

Change status in Google Sheet

  • October 19, 2022
  • 2 replies
  • 284 views

I have a board in monday.com. I want to automate the system more so when an item gets to a specific status, I want it to look for the item id and then change the text to No to Yes. How do I do that?

Best answer by Troy Tessalone

Hi @rada2647 

Good question.

Try these Zap steps…

  1. Trigger: Monday - Specific Column Value Changed in Board
  2. Action: Filter
    1. For the desired Status
  3. Action: GSheets - Lookup Row
  4. Action: GSheets - Update Row
    1. Map the Row ID from Step 3

 

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

2 replies

Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • Answer
  • October 19, 2022

Hi @rada2647 

Good question.

Try these Zap steps…

  1. Trigger: Monday - Specific Column Value Changed in Board
  2. Action: Filter
    1. For the desired Status
  3. Action: GSheets - Lookup Row
  4. Action: GSheets - Update Row
    1. Map the Row ID from Step 3

 


rachael.silvano
Forum|alt.badge.img+7

Hey there @rada2647 - were you able to get set up with your Monday.Com Zap? Let us know- and we’re happy to keep troubleshooting together if need be.