-
Countifs Formula Help!
The current formula is: =COUNTIFS(Due:Due, <TODAY(), Disposition:Disposition, <>"Complete") I need to count anything that is passed due and not closed, lesson learned or duplicate. I am utilizing a drop down box, too. Thoughts? Branden
-
Countifs counting
I am trying to count criteria in a couple different cells on my smartsheet. I am using the formula below: =COUNTIFS(RAID:RAID, "Action", Disposition:Disposition, "Open", Disposition:Disposition, "Retest", Disposition:Disposition, "Post Go-Live") I am trying to count any Risk, Action, Issue, & Decision and also factoring in…
-
Multiple If Statements
I'm having a difficult time making multiple 'If' statements work, cross sheets. I would like the sum of a column to be brought over to another sheet IF it meets the following criteria: 1. meets a corresponding category, and, 2. has a check box. The first half works (below), without the check box being checked: SUMIF({LGES…
-
Check boxes and formulas
Hello We are using Smartsheets to build ships.. but I have an issue with the formula(S) I want to be able to use a tick box for a formula.. We have many options priced and I want to use the tick box to generate option pricing. If the box is ticked then the price will move to the next column that is auto summed. If its not…
-
Whoaou !! whats happening with the Forms ???
Since 2 days when I add a row on the top using a Form the sheets are disorganized and the formulas are destroyed...am I the only person to have the issue ? When I had by the bottum, the formulas are not copied... It was workin until last week My sheet is in place since sevral week and got 500 rows No answer from the…
-
Trying to create Cumulative Flow chart from task list
I am attempting to build a cumulative flow chart based on new, active, closed tasks. The struggle is coming from trying to build a sheet with formulas that will pull the information from the task list and hold onto the information moving forward. Once the formula finds the correct data it continues to update each cell with…
-
Conditional formatting of dates
I have two columns set up, one with a arrival date and one with a start date. I want to highlight the cells in the start date column if the proposed "start date" is before the "arrival date." The purpose if to show that the activity can't start before the materials have arrived. Does smartsheet have this ability?
-
Help using OR in SUMIFS
I cannot figure out how to change this formula so it will add up amounts in the Stage Column that has a dropdown with several options. Right now, the below works, but I want it to work when the Stage is Verbal Commitment OR Written Commitment. =SUMIFS([Committed $]9:[Committed $]64, [Current Campaign Name]9:[Current…
-
RYG Balls average
hello, i am looking to find a way to do an average with the RYG balls. ex: 2 green, 2 yellow, 2 red should have should show yellow ball for the overall project. is this something possible? thanks for your help
-
Counting Due This Week
I am trying to count anything that is due this week. I have a due date column in my smartsheet, but what is the best way to count this information?
