-
Copy/Paste retaining formulas with multiple sheet & summary field references
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 consolidate our metrics into one central sheet for easy annual/quarterly updates as they are used across multiple dashboards. The…
-
VLOOKUP and links in the linked cell
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 from the link but not the link itself. Any idea? Thanks Kay
-
Cómo mostrar símbolos de manera automática mediante una fórmula
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 y cambiar la redacción para que funcione con cualquier tipo de símbolo. Comenzaremos con instrucciones IF básicas que…
-
IF OR NOT ISBLANK
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 change to Yes when Expiration date is not blank; and Expiration date is one day past todays date; or when Do you need to…
-
Countif element of a cell is one of a few options
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 it. Here's what I'm trying to do specifically: I have a contact list column that allows multiple people from my entire…
-
Auto Add a set of rows
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 smartsheet automatically do this .... If I have a master parent/child row sheet is there a way it will adjust if I adjust the…
-
Pesky COUNTIFS with OR formula
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 am trying to pull...Count if the following is true: 1) Project name is the same as the project in the summary sheet 2) Month…
-
Formula to determine is something is due this week
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 in a 'yes' for anything that is due in the next 7 days, which is not quite what I'm looking for. Is it possible to determine…
-
Sumifs with multiple criteria options within same criteria range
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. Essentially - look at Sheet (Field Movements). Give me a sum(total) of the "Da..." column (which this would equal 11) Criteria…
-
Search a data column and return the most recent past Saturday.
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 Saturday (weekending date) and the team completes it when they come in Monday for the week prior). I have a data collection sheet…
