-
Sumif/Sumifs question
I have a sheet that lists the number of awards that have been issued since the inception of the program. I want to create a report that breaks it out by year, award level (there are 3 different levels), and sum the total of that level. I have it by year, but adding the level I have not been able to figure out. Can someone…
-
Is it possible to Sum based off of status change in a different column?
For instance, if I had two columns, one is a number value and the other is a status value. if the status value is red and i wanted to sum just the values of the red statuses, is this possible by using a SUMIF Function. Thanks, Brendan
-
Functionality of dashboard with Forms on it
Hi, Created 3 forms for doing employee reviews with underlying grid sheets. 1 form is an Employee Self Review, 1 Form Employee Selection, and 1 Form Reviewer Form. Idea is a employee fills out self review, then sits with manager. Manager opens dashboard, selects Employee from Employee Selection Form, then clicks submit.…
-
How to convert my formulas to a column formula
How do I convert these formulas to a column formula? So the formulas work perfectly; however, I find myself constantly updating the source sheet when someone inserts or enters new records and then I have to go to my metrics sheet to make sure they are applied. I'm doing way too much manually work with these sheets and I…
-
If statement with dates
Hi there, I am trying to put a formula in a symbol column (Yes, Hold, No options) and want the formula to make the symbol for "Hold" if the due date is within 14 days of TODAY. This is the formula I have come up with but I am not getting the "Hold" portion =IF([Due Date]@row < TODAY(), "No", IF([Due Date]@row < TODAY(-14),…
-
Trying to multiply 2 cells- one contains a long IF & VLOOKUP statement
I have the following problem. I am trying to multiply the value of two cells. One is a numeric value entered into a form the other is the answer to a nested IF ( VLOOKUP) formula. I keep getting and #INVALID VALUE error. I need the result to be a $ value that comes from the length of rental period selected multiplied by…
-
I'm getting #NoMatch error on AVERAGEIF
I am using the Smartsheet JIRA connector to pull data into my sheet then I'm performing multiple calculations to get the % Complete for Stories (triple weighted score). I'm taking that calculation then rolling it up to the Epic (for all Stories) then the Theme (for all Epics). Formula for rolling up Stories to Epics:…
-
How do i make an empty or blank cell equal "$0.00" in Smartsheet?
I would like to make certain columns on a sheet that has empty or blank cells to show $0.00, rather than being blank. Can I create a formula that says "if a cell is blank, make it show $0.00"?
-
If then, multiplication formula
I'm trying to write a formula that will multiply two columns if there is data in both. If not, just = the one that has data. See attached example.
-
When activating "Colum formulas" the Cross sheet references become "invalid ref"
When activating "Colum formulas" the Cross sheet references become "invalid reference". The Cross sheet references to a big sheet.