Best answer

Issue with lookup and IF

  • 21 May 2020
  • 1 reply
  • 183 views

Userlevel 2

Hi, I am having some issues with the Google Spreadsheet and the conditions for the lookup.
 
I would like to update my spreadsheet cell. 
The issue is that to find the Row I have two options. Looking the Row with a Number or looking the row with a Name. The Number is not always available but it is more accurate. 

How do I tell zapier? 

- Lookup Number in Spreadsheet 
IF CANNOT FIND NUMBER 
- Lookup NAME in Spreadsheet
IF CANNOT FIND NAME 
- Notify me  

icon

Best answer by BowTieBots 22 May 2020, 13:48

View original

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

1 reply

Userlevel 4
Badge +4

@Fabs You will need to use Paths to do this.

Workflow looks something like:

 Look up Row by Number

  1. → If no row found → Path A → Lookup row by name → Filter step (If Now row found by name) → notify
  2. → if row found → Path B → Continue as normal