or Explore Discussions

# Formulas and Functions

Stumped by a formula? Ask for help or find examples to see how others use a formula to solve a similar problem.

## Discussion List

• What's the best way to set up a spreadsheet with monthly timepoints referencing a start date?
In Formulas and Functions
Hi all, I am looking to create a spreadsheet schedule that generates monthly timepoints from referencing a start date column. Is there a formula or method that would be useful? Thanks!
2 3
Answered - Pending Review 2 views 3 comments Most recent by Paul Newcome
• Formula to count the number of checked boxes in a column per person
In Formulas and Functions
Afternoon, I am trying to create a formula to count the number of checked boxes in one column per a person listed in a separate column. (So I would run the same formula for each person, with just switching out the person's name.) I conti…
Accepted
27 11
• IF STATEMENT WITH A RESULT IN SYMBOL
In Formulas and Functions
Hi im trying to archive that is this statement =IF(Price1>Price2,"Green Arrow") but not sure how to add the green arrow of the symbols is there a way?
Accepted
1444 5
• Counting how many days between to cells
In Formulas and Functions
Hello, i am trying to create a formula that will show how many days from the last delivery on the 23rd to the time before on the 13th based on the run name? a screen shot of the data is below. I would like a formula that would calculate…
Accepted
23 3
• I am trying to create a dashboard that will show me the totals of multiple pages
In Formulas and Functions
Hi all, I am trying to create a dashboard that will show me the totals of multiple pages. I want to be able to add rows to the bottom of the sheets and they get counted in the total.
Accepted
205 11
• IF with COUNTIFS
In Formulas and Functions
Im spending a lot of time trying to find a workaround for this type of formula below: =IF(COUNTIFS({UNIQUE_NFP_Dashboards data source Range 3}, <>"Complete", {UNIQUE_NFP_Dashboards data source Range 3}, <>"Did n…
143 4
Answered - Pending Review 143 views 4 comments Most recent by Paul Newcome
• Calculation with Dates - Strange Behaviour?
In Formulas and Functions
I have the following formula in my Due Date column: =IF(ISBLANK([Invoice Sent Date]@row), "Invoice not sent", [Invoice Sent Date]@row + [Payment Term (days)]@row) And when I test with the value 15 in the Payment Term (days) I get…
Accepted
11 10