Best answer

Convert the value of a Google sheet checkbox to a string

  • 6 October 2023
  • 2 replies

Userlevel 1



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?






Best answer by André R. 6 October 2023, 10:21

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.

2 replies

Userlevel 7
Badge +6

That’s awesome @André R.! Glad to hear you we’re able to get it sorted out!

Also, thank you for sharing the solution here, this will be helpful to our other awesome Community members who might have a similar question. 😊


Userlevel 1

Ok, found it myself: Format by Zapier Numbers and then Spreadsheet-Style Formula.