Formulas
Discussion List
- This just may not be possible, but no worse off if I ask. We have a 'table' of data constructed of cells with formulas using sheet references, and summary field references. We are trying to consolidat…
- Hey community, if I use VLOOKUP , and the linked cell (Cross reference to another sheet) itself contains a link, the result in the cell, where the Vlookup formula is inside, returns aonly the text fro…
- Esta publicación le enseñará cómo crear fórmulas para mostrar un símbolo de una columna de símbolos. Si aprende la sintaxis básica para crear algunas fórmulas diferentes, puede tomar la misma fórmula …
- I am trying to write a column formula to return a value of "Yes" if certain criteria are met but am struggling to understand what I am doing wrong. I need the column Removed From Respirator Program to…
- I am trying to find a formula that will return a count of how many elements of a single cell match my criteria. I am thinking some combination of a Countif, CountM... something? But I can't quite get …
- I have a data entry sheet set up for the year. Image below. I will have forty of these. Each of the forty sheets will have 10-15 children below the ALL parent row you can see. Is there a way to have s…
- Hi everyone, I have one of those pesky formulas that is giving me a hard time. This is for a Summary Sheet I'll use to build a dashboard so I'm referencing another sheet with the data. Here's what I a…
- Hi all - I would like to calculate if something is due this week based on a target date in another cell. I have tried this formula: =IF((TODAY() - [Week Of]1) - 7 > 0, "no", "yes") This formula pull i…
- I am trying to write a formula that will count the # of days that are considered "Time Off". I've put a filter on my source sheet with the needed criteria and need my formula to give the # 11. Essenti…
- Have not found this in the community, videos, courses, or formula template. CONTEXT: I have a dashboard that updates weekly. It has weekly data and a rolling 13 week chart. The date column is a Saturd…
