Hey friends,
I am syncing Airtable records with Google Sheets via Make.
The tricky part is that in Airtable “Status” select field the number of values is not the same as in Google Sheets:
In Airtable we have 3 values and in Google Sheets only 2 (identical to Airtable values).
Ex.
Airtable. Google Sheets
To do To do
In progress In progress
Deleted
Rejected
The goal is to ensure that if the selected value in Airtable does not exist in Google Sheets, the status field not be updated in the latter.
I have found a workaround in Airtable by creating a second status field > automating it to match only with the values existing in both places > mapping the second field. However, I would like to have the solution inside Make
Experimented in Make as well.
In the Google sheet “Update a Row” module I tried adding an IF formula when mapping the Status which would say, if a status value exists in both locations (ex. To do) take value from Airtable, otherwise take it from Google sheet (existing value in Gsheets, so that it will not change), but it doesn’t work.
Here is the scenario screenshot
Here is the formula I created. Experimented both with and without adding “Or” function. May be I am doing something wrong with formulas, as logically I guess it should work:)
Would greatly appreciate any help. Thank you!
