-
Formulas and Calculations
I know this is a simple formula in SS and Excel but I am having trouble writing it. In one of my SS's I want to Insert a "Beginning Miles" and then insert an "Ending Miles" column and then finally a "Total Miles Driven" column. To me that formula would need to calculated the sum of two entries and then yield a result of…
-
COUNTIF EXCEPT
Hello, could you help me find a formula that counts all except "x". I have a Column that has data such as: dates, "ok" and "N/A". I try using the Countif formula but cant seem to figure how to have it count all except the "N/A" information. I´d appreciate the help. Thank you!
-
IF AND/OR for Text Return
Hello, I have a tracking sheet that has three phases and each phase has a status, either "Not Started", "In Progress", or "Completed". I have an overall status column so I want to create a formula for the overall status that will return the value of "Not Started", if all phases are not started, "In Progress" if any of the…
-
Counting Checkboxes in a row and then showing the average %
I am trying to find the average of checkboxes in a row. At row: "Clear pads as needed..." I want the % to add up as each box is checked. What is the formula? Appreciate the help.
-
Hotkey - Ctrl "R"
Hello Smartsheets Community, I am aware the developers tried to mimic Excel's functionality as much as they were able to, but a fundamental hotkey I use in Excel is "Ctrl" + "R", which allows you to copy any cell to the right of the selected cells very quickly. When I attempt to do this in Smartsheets, my browser (Chrome)…
-
Formula needed
Hey Please see attachment. I need help with counting the number of cells in a column, (see attachment: Column [Response Sufficient?]) that contains an exclamation mark(hold) or is blank. I basically want to count the amount of RFIs with an exclamation mark or blank cell in the [Response Sufficient?] column. I have used the…
-
Help with #Invalid Data Type Error
I have a RYGB column (Color Status) that has a formula =IF(AND(Done@row = 1, [Parent Check]@row = 1), "Blue", IF(ISNUMBER([Days Open]@row), IF([Days Open]@row >= 240, "Red", IF(AND([Days Open]@row > 119, [Days Open]@row < 240), "Yellow", "Green")))) which is working to give me the red, yellow, green or blue ball. In…
-
Changing VLookups to Index Match using a Referenced Sheet
Help! I am completely lost on making an Index Match work for current VLookups, but I believe I need to figure it out to make my sheet more usable. I have a summary sheet template that has multiple Vlookups to a large master table. It is getting unruly to try to track the column #s (over 75) with a Vlookup. Every time…
-
IF Statement to return a Date value
I'd like to create an nested If Statement to return a date based on meeting a specific condition. I'd like to be able to "hardcode" the date in the IF statement. Here is a quick example =IF([Value]1 = "Option2", 4/23/2019, IF([Value]1 = "Option2", 4/24/2019, 4/25/2019)) . If the date is quote wrapped ed "4/24/2019" then it…
-
Simple Sum formula not working
I'm running into an issue where it appears the formulas that I have returning a number are not available for simple math in sum formulas. Any suggestions? For example, I have a column that produces the month a project will close based upon the estimated completion date currently linking in from the individual task lists. I…