I have a custom formula where I check the workbook for a certain cell color and return the sum. I also want to update the cell for the last date and time the function was run/updated. I currently have two triggers set up to run the countColoredCells function and updateCellValue function.

This question already has answers here: Refresh data retrieved by a custom function in Google Sheet (22 answers) Formula with custom script doesn’t update in Google Spreadsheet (1 answer) Closed 13 mins ago. I have a custom function in Google Apps Script called combineSheets() that is supposed to combine data from multiple sheets in a […]

I have an Apps Script function that returns the background color of a cell, however it requires the argument to be in quotes, ex: COLOR("A1").
I would like it to accept arguments outside of quotes, so that I can perform functions within the COLOR() function.
Here is the script for my function: