# True false formula in script

**URL:** <https://community.glideapps.com/t/true-false-formula-in-script/7601>\
**Category:** Ask for Help\
**Created:** [April 22, 2020, 2:29pm UTC](https://community.glideapps.com/t/true-false-formula-in-script/7601 "2020-04-22T14:29:28Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Mathan\_kumar](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mathan_kumar/32/1146_2.png) [@Mathan\_kumar](https://community.glideapps.com/u/Mathan_kumar)\
**Post date:** [April 22, 2020, 2:29pm UTC](https://community.glideapps.com/t/true-false-formula-in-script/7601/1 "2020-04-22T14:29:28Z")

</div>

var ss = SpreadsheetApp.getActiveSpreadsheet().getSheetByName(‘DUE’);  
ss.getRange(“G2”).setFormula(“=if(D:D=false, “NOT PAID”, “PAID”)”);

var lr=ss.getLastRow();  
var fillDownRange = ss.getRange(2, 7, lr-1);  
ss.getRange(“G2”).copyTo(fillDownRange);

THIS IS MY SCRIPT BUT IT SHOWING ERROR, ANY OTHER FORMULA FOR THIS CONDITION