-
How to Sum (Distinct Value Column 1 * the Qty in the same Row) + the Count of distinct in Column1
I am trying to create a formula that will Sum the (Distinct Value from Column 1* the Qty in the same Row) + the Count of distinct values in Column1 for a total to be calculated in another Sheet next to the Distinct value. There may be an easier or more straight forward way to do this but I am not sure. Below is an example…
-
Vlookup? Index/Match?
Need some assistance. Our fiscal months/years are a little wonky :). I have a sheet "Master Fiscal Year Dates" which provides the exact dates for each fiscal year, period, and quarter. In my accident tracking sheet, I need to pull in the Fiscal Year, the period, and the quarter from the Master Fiscal Year Dates sheet -…
-
Health Balls & Formula (Today's Date v. Follow-Up Date)
I need a formula (for Red, Yellow, Green) Health Balls in the "Follow-Up Status" Column, based on the date in "Follow-up Date" Column Red=2 weeks from Today Yellow=1 week from Today Green="Contract Executed Date" is NOT Blank
-
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…
