-
Enable move of formula editor window
Hello awesome people, Especially when working with large, complicated formulas, the color coding of the variables and corresponding cells is really helpful! (And shoutout also for making it so that when I paste formulas into onenote to work with them, the color coding remains. Great feature.) Unfortunately, the formula…
-
Uncheck Box
I have a formula that says IF(Date@row<TODAY(-14),1,0), to add a checkmark, but how do I add a formula that says once a next recurring date has been added to remove this checkmark.
-
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…
