-
I am trying to extract the first letter.
Hi Community, I need to extract the first letter from other cell. Please check the formula and help me. Please help me to get the correct values, If 'e' represents in the duration column then it should be '7' else '5' Thanks In Advance! Cheers!!
-
Countifs Error for 3 references
I am trying to get a metrics report for a dashboard for a log with multiple test cycles and multiple data. My metrics are by Status (New, Open, Cancelled, Assigned to Vendor, etc) Each of the Status options has to be filtered by the testing cycle which is either SIT or Deferred to SIT (I know I will have to do the same…
-
Add one more condition to check project status
Hi @Paul Newcome I'm able to calculate projects falls under on time and delay for the month, I would like to check "project status" column and check for "completed", =COUNTIFS({Month}, Label@row, {OTIF}, [Category 1]$4) im using this formula currently,
-
Formula to return the average of points assigned to a specific person within a specific date range
Hi all, I have a fairly complex formula I'm tying to create, and can't manage to make it work. Let's say my data sheet has three columns, representing a point value given to an individual on a specific date: Person (Number/Text, each cell contains one name) Points (Number/Text, each cell contains one number) Date (Date,…
-
If/Index/Match help!!
Hi! I am relatively new to Smartsheet. Usually I can poke along and work through to get the result. Today, not so much. I am trying to pull data based on data input. With the data, I need to match and select from one of 3 columns on another sheet. I have attached a couple screenshots. User selects accumulation from the…
-
Column formula to sum children
I am struggling with my formula. I have a helper column that identified Parents (1) and Children (empty) I have a column that contains a value for all children, I like to create a column formula that always provides a total of all children values at the parents row (yellow) when the parent has children. My formula has an…
-
Sum dollars based on names in multiple columns
I have a shared tips sheet. A big tip is divided by the coaches that are coaching for the group. If John is coach 1, Dave is coach 2, and Skye is coach 3, then the $30 tip would be split $10 each. The next group may have Skye , Mike, and Nate and may have a $60 tip. Etc. I am trying to write a formula that says of Skye is…
-
Index Collect value based on a date
I want to index a value if the "This Sheet Date" on my final result sheet is greater than "Date Value Effective" on my database sheet. Screenshots should help. I have a column showing the value that I want it to return. It's showing me the 2% because technically all of the "This Sheet Dates" are greater than the "Date…
-
How to sum total meeting hours members of a project will have to attend?
I have a Smartsheet that contains the meeting name, the number of hours the meeting will be conducted, and a contact list of the attendees of each meeting for a project. I would like to create a formula that will sum the total meeting hours each member of the project team will be expected to attend. For example, the…
-
Subtraction Issue when there is no input
Hello, I have two separate formulae to collect data based off of dates and input, I need a further formula to subtract one from the other, but I am struggling to get it to work. Subtracting them works fine, Cell v Cell, until there is no data input. I thought perhaps ISNUMBER might be a strong way to go but hit an…
