-
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.
-
Averageifs
Smartsheet does not appear to contain the averageifs formula. Is there an alternative that will perform a similar function. I would like to collect an average score of a sales person based on a text field which contains the region serviced. As there may be overlap in some instances I can not use the averageif option For…
-
How do I combine all cells based on specific text found in another cell?
Hi Smartsheet community! I have a from that our team uses to rank our vendors. The team selects 1st, 2nd, and 3rd place vendors and they have the option to leave comments for each vendor they select. As the results tend to involve the same three vendors, I need to find a way to "automatically" combine the comments into one…
-
Assistance with COUNTIFS formula...(New to Smartsheet/Formulas)
Hello, I am new to Smartsheet and formulas...I need assistance with a formula (creating a formula sheet for a dashboard). My formula references another sheet and I want it to count the IN-PROGRESS and UPCOMING Training for an individual trainer. I've created a few formulas that work, but not sure how to create them to…
-
Highlight duplicate values with a criteria within multiple select column
Hello I have this system where workers report with a form their done tasks and locations for those specific tasks. I am trying to avoid the option for them to do duplicate inputs. It works like this: worker chooses a task in form cell, then the locations where he did that task. They do multiple locations per form input, up…