Script to set up Goals % and Value


I have a table of orders, with their value in $. I wanted to create a dashboard that will show the current sum of the orders vs. a goal. Since there is no (as far as i found) a way to do that with the current apps, i thought of using a script.

Can someone share an example of a formula that will calculate the sum of raws in the tables and then will take a # and reduce that sum from it?


Hi @Sam_Mitrani - I’ve wrote a post about a similar scenario here - it might help you: