-
Deleting Cross Sheet References // Reference Manager
Anyone else not able to delete Cross Sheet References? I have a total of 8 CSR's that I have Deleted multiple times...but they keep showing up again in the Reference Manager. I even deleted the column in the source sheet that the reference was pointing to and they still won't completely delete... I submitted a support case…
-
Helper Columns & Sheet Summaries
Hi, Can you tell me how to link field from summary sheets into a cell on a different sheet in Smartsheet? I have seen other chats on using helper columns, but nothing that provides guidance on the proper formula to use to pull that information. Is there a way to do this?
-
Count if formula for starred/checkbox - help!
This might be a silly question but I'm stuck...a little rusty! I am trying to do a count formula for a dashboard that has a summary of how many sites are activated using this column whenever it's starred. The formula will be on a separate sheet used for dashboard metrics. Is it =COUNTIF(Sheet reference), HAS(@cell)) I know…
-
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…