-
Count of duplicate values in a column returns #UNPARSEABLE
I'm trying to count the number of requirements that are the same in a column. My research tells me that I need to use COUNTIF, but it returns #UNPARSEABLE This is the formula I'm using: =COUNTIF(({Requirement name}:{Requirement name}), ({Requirement name}@row)) Please help! PS: I am also counting the number of unique…
-
Trying to get data using the RIGHT formula
I have the following data where I am trying to parse the (ISPHUBS-6AAA) from the string below. Assets 1 = ORRR39-ORMOOO-BEACH (ISPHUBS-6AAA) I use the RIGHT formula ... =RIGHT([Assets 1]@row, FIND("(", [Assets 1]@row)) But I get the following string returned Result = -BEACH (ISPHUBS-6AAA) How do I get just the…
-
IMS to to do RAIL sheet
My IMS has a list of Critical Items that I would like tracked in a RAIL sheet Task Name, Start, Finish and Assigned to, Currently I have been coping and pasting these values into my RAIL my RAIL sheet column are Task name, Assigned to, Start date, Due date, Notes, Priority I currently use my RAIL to track meeting minutes…
-
SUMIFS formula
In my Sheet Summary, I am using the formula =SUMIFS(Shipped:Shipped, [Date Manufacturing]:[Date Manufacturing], YEAR(@cell) = 2023) + SUMIFS(Pending:Pending, [Date Manufacturing]:[Date Manufacturing], YEAR(@cell) = 2023) + SUMIFS(Scheduled:Scheduled, [Date Manufacturing]:[Date Manufacturing], YEAR(@cell) = 2023) across…
-
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…
