-
Summing $ from Multi-select dropdown that includes text
I am running into a problem that I have not been able to find in the community. I have a multi-select dropdown column that includes text and $ values, e.g. A - $25.00, B - $30.00, etc... I would like to take the selection from the column and sum the $ values. I would then multiply that by the Qty, =( )* Qty@row. I am able…
-
I need a if else formula
I am trying to create a formula that returns 1 if the value in the cell is created, then 1 else it returns that value that was originally in the cell. =IF([Total Sessions Attended]:[Total Sessions Attended] < 1, "1", [Total Sessions Attended]@row) [Total Sessions Attended] is the column I am looking at in the formula to…
-
Multiple IF(AND(OR statements to return a value
I am trying to find the correct formula for the following: IF classification is External Hire, AND Business Title is Assistant Store Manager OR Store Manager, AND Store Format is Steady State, THEN training duration = 42 IF classification is External Hire, AND Business Title is Assistant Store Manager OR Store Manager, AND…
-
Count total of a column only if another column is not N/A
Hi, I'm trying get a count for the number of items completed in my status column but I do not want them to be counted if the Target start date is N/A. Help! =COUNTIFS(Status128:Status133, "completed", NOT(CONTAINS([Target Start Date]128:[Target Start Date]133, "N/A")))
-
Need a SUMIF formula Contains or HAS for Category fund to total Budget in referenced sheet.
I need a SUMIF formula that will sum all Cat's in the identified operating budget. I thought I could use the CONTAINS or HAS but its not working. The category (not purple Budget Category) will have a number after but I don't need that number. The code in Cat is the letter (R, TO, E, TI) I need so it sums the revised…
-
Formula woes
Fairly new to Smartsheet and I can't get my formula to work, this is what I am trying do: If Due Date in Children row is less than today and Status is Not Started "Red", In Progress "Yellow", Done and in Review "Blue", Complete and Closed "Green". Thank you in advance!
-
SUMIFS - COUNTING VALUE AGAINST EACH OPTION IN MULTIDROP DOWN WITH ADDITONAL CRITERIA
Hi there, I am trying to sum the total target customer number per month per specific product. The product appears in a multi select dropdown column. For more context; we might have an event with 4 products, if the target customer number is 20 essentially I want to be returning the count as 20 customers targeted for product…
-
Looking for a formula, to add the total of an invoice column, with a criteria from another column
I have 2 columns, one the Invoice Amount & Location. I want to be able to calculate the total of the Invoice Amount Column, with a criteria in the Location Column Hope that makes sense Many thanks
-
Change Pivot Table Column Names
Hello, Q1: My end goal is to be able to index collect via pivot tables, is that possible? I noticed that my pivot table automatically "adds" to the column name than initially intended. Is there a way to change that? I just want the column headers to be the first 3 letters of the month, which was I originally have it mapped…
-
If formulas with Parents & Children
Hello All, I have been looking for some help with a formula between parents and children. The goal is to have a column to pull a report off of so when it pulls we know it was a child and not just a regular line. The formula works for a Child but when we want the Parent line in the column to pull the parent data it shows up…
