-
I would like to make a column name equal to a cell.
I would like to make a “text/number” column name equal to the a cell located in the first row of the column, can this be done with a formula?
-
Join Collect multiple columns from another sheet
I have this growing reference sheet with Site_Name and respective emails (1-3). Not all of them have all 3 emails. Please also assume that the emails are not beside each other. They could be 2-3 columns apart. I need to merge their emails on this order tracker, but not sure how to use Join Collect if there are multiple…
-
Formula to Determine NEXT DATE from a group of Dates
I Have a series of Go Live Date columns in a Smartsheet and I want a new column called "Next Date" that determines which of the dates is the next Go Live date. I using the following formula but it doesn't return any value: =MIN(COLLECT([Release 1 Go Live]@row, [Release 2 Go Live]@row, [Release 3 Go Live]@row, [Release 4 Go…
-
#INVALID DATA TYPE error when IFs are combined
Hi all, I've got this formula here that basically enters name of the month in the cell based on date: =IF(MONTH([Date of Defense]@row) = 1, "a. JANUARY", IF(MONTH([Date of Defense]@row) = 2, "b. FEBRUARY", IF(MONTH([Date of Defense]@row) = 3, "c. MARCH", IF(MONTH([Date of Defense]@row) = 4, "d. APRIL", IF(MONTH([Date of…
-
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