Hi,
I suppose this is a basic action but I can't figure out how to do this….
I have a column in a Google Sheet that is a checkbox. Depending on the status (checked or not), I want to assign a value to a variable that I want to use in a later step in the zap. Something like:
if (option == true) {label = "LEFT”} else {label = “RIGHT”}
And then use the value of 'label’ further in the zap.
How do I do this?
Thanks,
André
Best answer by André R.
Ok, found it myself: Format by Zapier Numbers and then Spreadsheet-Style Formula.
Ok, found it myself: Format by Zapier Numbers and then Spreadsheet-Style Formula.
+6That’s awesome
Also, thank you for sharing the solution here, this will be helpful to our other awesome Community members who might have a similar question. 😊
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
