-
Formula to find total amount assigned to someone?
Hi all, I hit a bit of a stumper and I was hoping to see if someone might be able to help. I need to find out how much square footage each person covers within a table, something similar to this: Since multiple people can be assigned to a specific building, I would want to divide the square footage by the amount of people…
-
Formula for at-risk flag, due within 3 days
Hi! I would like to have my at-risk flag turn red when 1) a due date is within 3 days or past the due date and 2) its not completed. I am using the below formula but it doesn't work: =IF(AND([End Date]3 < TODAY(-3), NOT(Status3 = "Complete")), 1, 0) I tried it with making it TODAY() and it works for overdue items, but I'd…
-
IF formula when multiple options are selected
Hello! I'm trying to see whether or not there's a way to create an IF formula based on one of several options select in a multi-select pick list. One of the fields that my current IF formula is based on has a multi-select pick list. If users select multiple options within that pick list, the formula doesn't formulate. The…
-
How to count rows if box is checked in separate column?
I have a helper column to identify the columns that require data to be entered. I need help creating a formulat that will do the following: Count the total number of rows within a specific range of the "Entity Details" column, and have a box checked in the "Data to be Entered Column". (For example Rows 10-25, that have a…
-
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…