-
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…
-
Could anyone help us create the proper formula? Parent/Children Health based off Due Dates
We are trying to utilize Smartsheet to list out, follow, and forecast our project schedules. The idea is that each Milestone of the Project is the Parent and the steps within the milestone are the children. We are having issues with the parents correctly representing an issue/delay within its children. Right now the…
-
How to COLLECT() a different reference value for each value in a multi-select column and SUM() them?
I have a cost matrix similar to this staged one: The cost matrix is referenced in a second sheet of "buyer requests" to determine the cost of their request based on the Type, Size, and Vendor they chose: When only ONE Type of Material is requested, the following formula works: =INDEX(COLLECT({Cost}, {Vendor}, [Preferred…
-
Parse Out Number Values in Successor Column
I have found multiple threads on this but I can't seem to get any specific formula to work for me. I have a column to Join Successors =JOIN(SUCCESSORS(Name@row), ",") The highest number of Successors I have is 4 and I'm trying to parse them out into separate columns. I have formulas that work for three but can't figure one…
-
Formula that calculates the multiple choices chosen from a drop-down list
I need a formula that calculates the choices from a multiple selections row. I am currently using the formula =COUNTIF({Link Access}, "Overdue Report")
-
Budget Tracking
Hi, I'm trying to put together a budget for change orders and I want to have the value of the "total" cell of the change order show in a "remaining" cell if "NO" is selected from a drop down. I have been messing with the automation for an hour and I just can't figure out what the formula needs to say to show the value.…
