Help

Automation to append row in google sheets showing/posting 1's only

Topic Labels: Automations
263 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Tawanda_Madamom
4 - Data Explorer
4 - Data Explorer
I have a mysterious issue
 
I have a field with this formula: IF(language_assessment_label="English",0,IF(SEARCH(TRIM(language_assessment_label),""&assessor_accredited_languages)=0,1,0))
 
It works very well in Airtable. However, when the automation transfers the column's values to a Google sheet,
for some reason ALL the values are added as 1's, I repeat ALL the values are added as 1's. Even if the value is 0 (zero) in Airtable when it gets to the Google sheet it becomes 1.
 
I have a lot of other formulas which do not have the automation issue.
 
0 Replies 0