-
Formula Help - Count If (percentage complete)
I'm looking help on a formula to find the "Percent Finished", in row 1 column 1, by counting the total number of "Test Status" entries of: "Completed, Previously Enrolled, Enrollment Not Needed, Client Did Not Approve" and Dividing it by the count of "SAP ID"s. Thanks! Mary F
-
Exclude Rollup / Summary Tasks from Summary Sheet
Hi All, My Smartsheet has Rollup / Summary Tasks, Deliverables/Tasks and Milestones. On the Summary Sheet, I only want to count the actual Deliverables/Tasks i.e. not the Rollup/Summary tasks or milestones. I found how to add a column that determines whether a row is a child or a parent using - =IF(COUNT(CHILDREN([Task…
-
Pull data from Multiple sheets into single sheet and still allow to put formulas
Hi, I have different sheet for projects but I want some key specifics in a single sheet that could allow me to use this data later to present the billing and other related aspects of the work. Here's how it works: Project plan sheet: This contains the project plan, start dates, end dates and the %complete. For an instance…
-
If cell is empty or blank, I want to automatically enter a 0.
I'm not sure how to automatically enter a value of zero if a cell is empty. Is this possible? I tried to enter the formula below (and various iterations of it) but I get errors. The error for below was "unparseable". =IF([% Complete]1:[% Complete]17, ISBLANK, ("0")) Anyone know if this is possible? Thx, Deb
-
Is autofill possible in this scenario? and how
I am working on a calendar form and I would like if I entered a specific name of an event, that the next column would autofill a number. For example, if in the "event Name" column I type "Marathon", I would like the next column to autofill with 18000 for the expected participants. Is there a way to do this? Thanks
-
How to not skip ranks and deal with ties?
Hi all, I worked with the Prodesk on using the RANKEQ function which was helpful, but I am realizing I have records which are ties. Essentially I have a column which ranks our projects; if the weight is 0 it's "not ranked" and should be thrown out of the rankings, if it's anything else it's ranked. The formula is as…
-
If Statement with nested VLOOKUP formula
Hi! I would like to return a value from another SmartSheet if one column in that same SmartSheet has a "Y". I have the current formula below, but it's returning a #NO MATCH error... any thoughts? In summary: return value in column A of SmartSheet Y to SmartSheet X if coulumb B in SmartSheet Y = Yes.…
-
Calculation within IF statement
Hello, I have a column formula that calculates the number of days between a ticket request and the completion date. I want the rows that do not yet have a completion date to be blank instead of "#INVALID DATA TYPE" and I tried to use to IF statement to do that - If completion date is blank, leave the cell blank, otherwise…
-
Simple row multiplication formula
Hey all. Looking to have a row for an MSRP where the row shows the suggest 15% markup on a row. For example say row named COST is $100 and I want a markup of 15%, I want to create a formula to multiple COST row * 15% I am multiplying 1 row by a fixed number. I am not multiplying two rows together. What's the correct way to…
-
Simple sell date - buy date formula
Hey all. Trying to do a column equation that shows how long an item has been sitting on a shelf. Lets call the two columns Sell Date and Buy Date. I'd like to see the amount of days between Sell Date and Buy Date. If I bought inventory on 1/1 and sold it on 1/10, I'd like it to read "9' for "Days on Shelf" column. What's…