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
-
Showing the start/end date in a project plan in multiple time zonesIn Formulas and FunctionsHi, I am developing a project plan for a global team. I have built a project plan that shows the start and end times in PST but other team members would like to see when a task is going to be triggered in their local time zone. In MS Pr…
-
Cross-Sheet COUNTIFS helpIn Formulas and FunctionsThis discussion was created from comments split from: COUNTIFS Referencing Other Sheets.
-
Counts of values in a multi-select columnIn Formulas and FunctionsI'm trying to count the number of values in column that allows for multi-select. In this case, column is Contract Type - and the request can involve multiple contract types...I'd like to be able to count/total individual the types of cont…
-
Issue Rolling from 2019 to 2020 with Duration Function Formula to Determine Overall StatusIn Formulas and FunctionsWe are using the following formula in a project sheet: (TODAY()-StartLine#)/DURATIONLine# Example Schedule Activity Setup: Task Name - Start Date - Finish Date - %Complete - Status - Duration - Calc In the Calc column, is the above formula…
-
=AVG functionIn Formulas and FunctionsI'm trying to get an average sales total for 2020. We are only on week 7 but it counts ALL 52 and averages it out. How can I get the function to work so it only averages the current week and prior weeks?
-
Combining a Symbol & NumberIn Formulas and FunctionsHello, I have a column that calculates Q/Q growth and displays it as a percent. The next column shows that as a symbol based on an if statement. For example, Q/Q growth is -61%, then the down arrow is displayed. I'm building a dashboard, w…
-
Week number @row functionIn Formulas and FunctionsIs there a more efficient way I could write this formula? I'm looking for the week number and I physically have to go in and change it for each cell. I would like so I can just copy down the formula. Also, a more efficient way to report d…
-
how many days task took per specific month?In Formulas and FunctionsHello, Maybe someone could help with formula preparation. Example: I have a task that lasts for several months (06.02.2020- 18.04.2020). How to calculate a numbers how many days task took per specific month (separately for FEB, MAR, APR)?…
-
SUM function not working on cells with formulaIn Formulas and FunctionsHi, I faced an issue with the SUM function, since it seems to not work on a column in which the cells contain a formula to return a number. The cells that i want to SUM contain (JOIN(COLLECT)) formulas that pull data from another sheet. Wh…
-
Parent/child formula working/not working depending on position in hierarchyIn Formulas and FunctionsUgh! I have 3 drop-down menu columns to indicate pass/fail/untested, in a QA testing sheet. Via rows with parent-child hierarchy, the sheet is further divided up into test months, weeks, cases, and sub-cases. Toward the goal of ultimatel…