Best answer

Convert the value of a Google sheet checkbox to a string

  • 6 October 2023
  • 2 replies
  • 200 views

Userlevel 1

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é

 

icon

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 1

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

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. 😊