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 FunctionsHi 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!
-
Formula to count the number of checked boxes in a column per personIn Formulas and FunctionsAfternoon, 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…
-
IF STATEMENT WITH A RESULT IN SYMBOLIn Formulas and FunctionsHi 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?
-
Counting how many days between to cellsIn Formulas and FunctionsHello, 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…
-
I am trying to create a dashboard that will show me the totals of multiple pagesIn Formulas and FunctionsHi 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.
-
IF with COUNTIFSIn Formulas and FunctionsIm 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…
-
Calculation with Dates - Strange Behaviour?In Formulas and FunctionsI 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…
-
Hello I need to add a risk identifier to a dashboard, =COUNTIF(Risk,1) on my Sheet Sum isn't workingIn Formulas and Functions
-
Incremental Budget Forecasting based on Monthly Due Date PercentagesIn Formulas and FunctionsIn excel, we have two sheets: Sheet 1 - A percentage breakdown per country based on historical data for each Month prior or after the Due Date month. Zero = Month Due Date. -1 = the Month prior to the Due Date Month, etc. Sheet 2 - For C…
-
Create formula so that when data changes in one cell, it overrides in anotherIn Formulas and FunctionsHi there, I am building a Project Plan and in it, there is a Days To Go column calculated with a formula (=Deadline2 - TODAY()) based on the number of days we have left to complete the task, based on the date we manually input in a Deadli…
