In Google Sheets I have one column of data that is confiditionally formatted to rank the data and colour code it depending on where it sits in the percentile. I achieve this by using the following

To get round not being able to ‘click’ buttons in GoogleSheets when using a cellphone I’ve created an onEdit Trigger to operate a function that runs when a checkbox in cell D5 on a particular sheet is checked.
The script works well but if I uncheck the checkbox the script runs again.
Is there anyway to prevent this?

My table is as follows:

image here

I was trying to install the gsheet package in R 4.4.1 but I ran into an issue.

I am currently writing a script for my Google sheet to convert any currency to Euro base on an specific URL. The thing is I’m not able to make it work. The following message error shows up on cell “N2”: No valid entry found for the date 6/1/2024.

i want to set unprotected diffrent ranges in many tabs in my spreedsheet
i used this script below and it works but can we edit it to add different tabs with different ranges

I will try to be as descriptive as I can in what I am trying to do, bear with me, it’s quite long.

I’m trying to update this code chunk so that the installable trigger (onEdit) is only triggered when one single column is edited. I have a manually triggered (via button) via this script

I have a sheet of Data (Unifrog interactions (without Benchmark 8)) that on another sheet (Benchmark 4) I have filtered in Cell A2 to make sure I only get data in Column G that has “4.” in it. All is working fine but I would like to then maybe use the =Unique function to only get records based on unique entries in Column D of the Benchmark 4 tab.