-
Count formulae
Hi all, Need a bit of help with constructing a formulae to input into a sheet summary box for the below situations: To calculate the count of 'Medical Device Related' category from the 'Relevant System' column Same as the above but for 'Non-Medical Related' category I want to have a breakdown of the sub-categories for each…
-
Need function or @row formula to get attachment URLs (Index if multiple attachments).
Need a function or @row formula to get the specific attachment URL for any row attachment. This function could be used in a column so @row.GetAttachmentURL(Index) would return a URL. This is similar to the URL generated when the Attachment ->Send email menu option is used. This would allow Automation workflows to send…
-
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…
