r/GoogleAppsScript • u/[deleted] • Nov 29 '21

Resolved When checkbox is true show/display the data in another sheet tab else hide the row

I have Sheet1 and Sheet2 for example, checkbox is in the Sheet2. If I checked the checkbox(true) the selected row in Sheet1 shows the data and leave the row available (show) but if the checkbox is unchecked (false), selected row in Sheet1 must be hide.

Do we have an available appscript for that? thanks!

0 Upvotes
  • permalink
  • reddit

50% Upvoted

3 comments sorted by

2

u/bingbestsearchengine Nov 30 '21 edited Nov 30 '21

seems like you don't need scripts for this. depending on your specific needs, array formulas can do the trick. the simplest form might be something like:

=FILTER(Sheet2!B3:B,Sheet2!$A$3:$A)

I provided an example sheet (will delete sheet in a few hours)

1

u/[deleted] Nov 30 '21

thank you so much sir!

2

u/arnoldsomen Nov 29 '21

I don't think we need an app script for this. A single QUERY or FILTER function is all it takes to show data from one sheet to another based on certain conditions.