-
Adding a 3rd criteria -- help with Syntax
Intent: Collect the amount of Non-Billed Payments for a specific timeframe if the payment type is 5. *** Definitions: Separate Metrics sheet used to collect the following -- > Sheet/Column {Non-Billed Payments Date Paid} is a date field in a referenced sheet [Range Start] [Range End} are date fields for the first and last…
-
Can I have "does not contain" as a SUMIFS condition?
Hi. I'm trying to write a SUMIFS, and I'm having some trouble. I want to make "does not contain" one of the conditions. I have previously achieved something similar outside of a SUMIF by nesting the CONTAINS formula within the NOT formula, but I can't get it to work here. I think I am doing something wrong with the range.…
-
RFQ and Invoice
Hi Team, I am trying to find a template to create/form a RFQ for a customer and then turn that into an invoice. So for clarity - customer ask for a quote to build a product that has multiple steps to complete. for example: Purchase metal, cut metal, shape and form metal, weld metal, pain and ship. Steps and processes might…
-
Conditional Approval & Approver Automation
Hi - I've been trying to come up with the best way to implement a process into Smartsheet and can't really come up with an ideal method. Hoping someone can give me an idea or point me in the right direction. We have a process where a user submits an intake item and then it goes to a general group for them to review/update…
-
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?
