Torch Project Management Functions in Google Spreadsheets with Google Apps Scripts

When you install Google Apps Script, you have two methods of using it:

  1. You can initiate functions from the menu
  2. You can type in the custom function names directly, just like any formula

This is a reference of the available function names in Torch Project Management’s Google Apps Scripts.

Torch Project Management Financial

  1. =TotalCategoryCost(category)
  2. =TotalUserCost(user)
  3. =TotalProjectCost(project)
  4. =ExpenseCategoryCost(category)
  5. =ExpenseUserCost(user)
  6. =ExpenseProjectCost(project)
  7. =TotalInvoiceBalance(invoice state)
  8. =TotalProjectBalance(project)
  9. =TotalCustomerBalance(customer)
  10. =TotalInvoice(invoice state)
  11. =TotalProject(project)
  12. =TotalCustomer(customer)

Where “category” is the category name, “user”“ is the posting user, ”project“ is the project name and ”invoice state“ is the invoice state (e.g. ”draft“,”open"). If I wanted to specify a parameter value directly, I might type something like:

=TotalCustomer("John Doe")

But I also might reference a cell:

=TotalCustomer(C9)

Torch Project Management Activity

  1. =CountEvents(project,category,pinned,complete)
  2. =CountMessages(project,category,pinned)

Where “project” is the project name, “category” is the category name, pinned is if the message or event is pinned (“yes” or “no”) and “complete” is if the event is complete (“yes” or “no”). If I wanted to specify a parameter value directly, I might type something like:

=CountEvents("Torch Project Management","Code","yes","no")

But I also might reference cells:

=CountEvents(A2,B2,"yes",C$2)