I am running a function in App Script "getValue" only gives me 0.0 from a cell that has a conditional formula in it.
OR(COUNTIF(Sheet7!$K$2:$O$2,1)=3,COUNTIF(Sheet7!$K$2:$O$2,3)=3,COUNTIF(Sheet7!$K$2:$O$2,4)=3,COUNTIF(Sheet7!$K$2:$O$2,5)=3,COUNTIF(Sheet7!$K$2:$O$2,6)=3,COUNTIF(Sheet7!$K$2:$O$2,9)=3,COUNTIF(Sheet7!$K$2:$O$2,10)=3,COUNTIF(Sheet7!$K$2:$O$2,11)=3)=TRUE,(A8*216)+A8
How do I get app script to return the value in the cell? When I run Logger.log(win) I get 0, not the calcuated value in the cell.
My function is:
"function Gains() {
var ssWs = SpreadsheetApp.getActive().getSheetByName('Slots');
var win = ssWs.getRange('B3').getValue();
var values2 = ssWs.getRange('A3').getValue();
var cashGain = values2 + win;"