-
Formula in Resource % Allocation column
I have added a column to put in the number of hours I would expect the task to take each day. I prefer this to having to work in percentages of a day and think this will be easier to request of my team. To allow this I need to put a formula in Resource % Allocation column to divide the number of hours by the number of…
-
Auto updating a status
Hi, I am looking for some help with a formula please? I have a scheduled date which is static, Column name "1st Scheduled" i then have a completed date, Column name "Completed date" I am trying to have the status column update to "Overdue" if no date is entered in the "Completed date" and today is past the "1st Scheduled"…
-
IF Statement Help
Hello, everyone - I'd really appreciate some help writing a conditional formula for a field entitled "Aging Type". There are 4 valid values for the field - Waiting on Approval Waiting on RFx Waiting on PO Waiting on Payment Waiting on COP The values are based on seven columns - ECM/IM Approved RFx # RFx Sub'd PO # COP…
-
Formula Writing-COUNTIFS & SUMIFS
Hello, I am trying to get a couple formulas to work to filter down a roll up sheet. I have tried the following formulas to no avail: =COUNTIFS(Phase 3:47, = "Leads", [ Phase 3:47, = "Closed"], [Phase 3: 47, = "In-Service"], [Phase 3:47, = "Closed"]) =SUMIFS(Total Project Cost(), Phase()="Leads") Let me know if there is…
-
Using COUNTIF to determine quantity of rows with number not ending is 000
Hello, I'm trying to setup a "Line Quantity" of children where the primary column contains a 5 digit number. These numbers indicate line items of a purchase order and have a hierarchy themselves. The numbers that are considered the parent end in 000 with all the items that are children end in various numbers in increments…
-
VLookup or not
Im working on a scrum dashboard and want to show the actual sprint name. The Sprint Name (e.g. Sprint 01, Sprint 02...) is in the primary column at Level 2 (task at Level 3 and Release at Level 1). I have a column with the status ("Do", "Doing", "Done") and only one Sprint can be in the "Doing" status. On my metrics sheet…
-
workday calculation with if conditions
Hi, I'm trying to add a workday function to my current calculation. I already use if condition in the cell. Here's what I have. If location is Riverside, then add 3 days to ETA. If location is Memphis, then add 5 days to ETA. IFERROR(IF(Location1 = "RIVERSIDE", ETA1 + 3, IF(Location1 = "MEMPHIS", ETA1 + 5)), 0) However, I…
-
Strip Time When Linking Max Modified (Date) Cell to Column with Restrict to Dates
Hi Smart Sheet Community! I am applying a formula to a cell in our project schedule sheets that I found in a couple posts to grab the MAX value of the Modified (Date) column: =MAX(Modified:Modified) + "" My colleagues and I will be linking the cell with this formula from our project schedule sheets to a "Last Updated"…
-
SUMIF
Hi, I'd like a formula to calculate the below SUM the leave days Request(Column Number of Days) against the employee(Name Column) if Approved(Manager Column) and Approved(EXCO Column). If either one of them are not approved then don't SUM the leave days. This is what i have so far but cant seem to get it to work.…
-
Count checkbox and text in a column
Hi, is it possible to count in a column, if I have check box and also N/A ? I need to count every cell that has a check in the box or the N/A. Thank you !