-
INDEX/MATCH for Multiple Criteria to create single row
Hi all, and thanks in advance for helping, it is greatly appreciated. This was a solved problem, until it was determined that each Release and the stages needed to be on 1 line, rather than 1 for the releases and then the 7 phases below. The first sheet in my data file which I am linking from. This sheet is owned by…
-
#NO MATCH error on a Sheet Summary Formula
Hello, I'm guessing the problem is because the field I'm referencing is a formula and not a value, but would appreciate suggestions on how to handle this. I want a sheet summary formula to return how many Variances exist for each VarianceCategory, so I can use this information in a report. I've listed the formulas that I'm…
-
Manpower Loading Schedule
I am trying to create a Project(schedule) that has a manpower loading functions. I am almost there but I am stuck with trying to figure out how to see how many crew members I have on a certain days by suming them up. For example I would like to have a list of dates and then show how many crew members working on those…
-
Nested Formula Help
I am trying to use this formula and it is not working. Does anyone have a suggestion on how to fix? =IF(AND(ISNUMBER(Results@row, ISBLANK([Results Symbol]@row, Results@row > [Conventional Spec]@row))), 1, 0)
-
Reference Comment in Formulas
Please add functionality to address comments via formula, such as =countif([Comments]@row, "No Change") to simply count how often in a row a project is listed as "No Change" or how often something is commented on with =count([Comments]@row). This would add functionality for tracking KPIs and Leading Indicators which is…
-
How do I best link a list of entries in one column to an entry in another column?
What I'm looking for is the ability to create a list column called "Product" and have another column called "Options" which would have another list of entries filtered based on the selection in the "Product" column. Any help would be greatly appreciated.
-
Sum of Children not working
I have 1 Sum of Children formula not working and can't figure out why it isn't working. Here are some screenshots. What am I missing. It keeps giving me $0 where the formula is and should be giving 182.16
-
Cross Sheet Reference COUNTIFS
Hi there, I'm fairly new to Smartsheets so I apologize if there's an obvious answer to this question, but here's my situation. I have a sheet that tracks projects and their status. Along with the status column, there's another column that auto-populates the date a project is marked as "Completed". I want to create a metric…
-
Formula won't recognize values as numbers
Hi there! Problem = I have four "Text/Number" columns that I want to average Complexity = the column values are derived from formulas Issue = when I try to average all four columns with =AVG([Stakeholder Score]@row:[Complexity Score]@row) formula, it keeps throwing an error. Even when I try the long way around…
-
Referring to a Cell in Another Sheet that Contains an Hyperlink
I am wanting to refer to a cell (or find a match in a range of cells) in Sheet 1. The cell in Sheet 1 contains a hyperlink. What I get in Sheet 2, however, is just the text in the cell, not the text as a hyperlink. Sheet 1 (contents of cell, text as hyperlink): BUS 123 6Wk Online What I get in Sheet 2:(text but no…
