-
Need Formula to count if cell values are Greater than 0.5
I have tried several different formulas to determine how many cells have a value greater than 0.5. The cells are qtr 1, qtr2, qtr3, qtr4, qtr5, qtr6, qtr7, and qtr8. The cells are not next to each other so it can not be a range. Any suggesstions? Forrest
-
Percentage of Total Tasked Complete
Good afternoon everyone! I am trying to format my "% Complete" column to auto populate when changes are made to my "Requirements Total" and "Requirements Complete" (i.e. If I have 10 requirements in my Requirements Total column and I have completed 5 in the requirements complete, which would make my "% Complete" column…
-
Formula for addition of quantities
Good afternoon, I am attempting to create a formula that adds the sum of multiple quantities. How would I create this formula and assign values to different types of information within this formula?
-
Unparesable Error
Receiving unparseable error when selecting a field in one column and wanting a specific result in another field. This is the formula. What am I missing? =IF([Submit for Approval]1,1[Manager Approval]1 = "Submitted") See attached
-
Formulas
Hello, I am needing help with this formula =IF({Colunm Range 1} >= 10, "Met", "To be Started") (this works but will not be relevant for the whole year.) How can I add in a date? I was this formula to recognise if a range is equal to or great than 10 after the 01/03/19, "Met', "Risk" Also can you AVG Harvey balls at all????…
-
Reference a Report
I am using a form to track time spent on projects. Right now, they select the project from a dropdown list that I manually created and then they type in the task and the hours worked. Ideally, I would like for the Task Name to populate according to those available based on the Project selected. For example, if the user…
-
Symbol Formula
Good morning, I am inquiring about a formula that adds a quantity of certain symbols within a sheet. I would like the total of check marks to be added. Attached is a screenshot of what I have unsuccessfully attempted thus far. Please let me know what changes are needed. Thank you
-
IF Statement Help
Hello All, I am trying to create a smartsheet to optimize a process. Basically what I need is a statement to recognize if a cell has a specific text value (for example CUP). If the cell contains the value, I need the cell, that I am writing the statement into, to display text (for example Andrej). I tried to use the IF…
-
SUMIF value exists, leave blank if cells are blank (nothing to sum)
I'm trying to figure out how to create a formula to sum a column if there are values, but leave the field blank if there are no values in the range. Is that possible? Here's the background: I'm trying to create a status report that shows whether or not someone has actually entered values into the appropriate column. If…
-
Please help with a formula!
I am looking to compare Year to Date numbers, and I'm having a hard time figuring out a formula to do so. I've attached a sample screen shot. At the end of the day, I'm trying to add a metric into a dashboard that shows 2018 vs 2019 year to date. I created the "YTD" column that shows the value of the last column that has…