-
I need formula to count everything but Blank cell?
The Black cells are blank cells. I need a couple of formulas 1-that will if me a total of non-blank cells. 2- be able to compare "MS" cells to the "SS..." cells. Im looking to create a dashboard I can use to display
-
If Statement for Colored Balls
Hello, I am trying to create an IF statement that says IF there is one or more red ball in the range below then the green ball turns red OR If there are one or more yellow balls I would like the green ball to turn yellow. Otherwise, the ball stays Green. So far here is a simple attempt just trying with the first portion of…
-
SUMIF error
I'm stumped on another formula. I receive an "incorrect argument set" Total [Dave Delivered] if the month is January =SUMIF([Actual Date Completed]3:[Actual Date Completed]46, MONTH(@cell) = 1, [Dave Delivered]3:[Dave Delivered]40) Thank you
-
What formula do I use for Grading?
I have a sheet used for grading our product. There is a final score for each product out of 36. I would like to use a formula that uses the final score to give the product a "Grade". 0-12 = C, 13-23 = B, 24-29 = A, 30-36 = A+ How do I set up a formula to kick out a letter grade in a cell depending on a range of numbers in…
-
Helper Sheet Help
@Andrée Starå has mentioned on multiple posts about creating Helper Sheets when trying to manipulte data to have certain rows copied to other sheets. I'm completely stumped where to start with the cross-reference formulas to make that happen. I have a master sheet with a lot of columns, some of the data in the master needs…
-
Max Collect formula help
Hello I can't seem to troubleshoot this formula. Return the latest date [Planned Date Completed] associated with "1" [SOW Billing sequence]. Any idea why it's returning 0? Thank you! Lauren
-
Too many Formula Cell references
Hello, I received this warning in my Smartsheet and am not sure why? I have about 36 columns and ~2400 rows, 11 columns are formula columns. Do I have too many formulas? I have 6 cross sheet references. Appreciate any help.
-
Incorrect Argument Set
Please help: why am I getting this "Incorrect Argument Set" =SUMIFS([Targeted Area]:[Targeted Area], "Atopic Dermatitis", [Approved 2022 $$]:[Approved 2022 $$], 1) This formula uses 2 columns [Targeted Area] and [Approved 2022 $$] (which has the $$ approved amount) and says... look at the "Targeted Area" column, if it is…
-
Display Hours & Minutes (Time) as Minutes
Good afternoon all, I have a column that displays time taken to do a task in this format: H:MM I would like to have a column at the end of my sheet that displays this information in minute format. Please can you help with the formatting. Thank you
-
Using IF to return a value from another cell
Hi All, Currently we have the below system in place to return the value of a specific cell out of a specific column. So for example, If the country is Germany it pulls the information out of the Germany Column. This works great! But now comes my problem. We have added a Germany Refurbishment Column. So now it should work…
