-
I need help with the right "IF" or SUM IF formula
I want the formula to do a few things. 1 - Check to see if the row has CHILDREN and if it is a "Rollover PO" I have a helper column that is "CHECKED" if it is a parent I also have a column for "Rollover PO" 2 - If both are checked THEN I want the formula to SUM the CHILDREN in column [Total PO Spend] 3 - If the column…
-
Pivot Table Dates
I've created a pivot sheet using the Pivot App that includes a date of when a call was taken, however I'm having no success creating an actual date column from the column created by the Pivot App. Please see below for formula reference. Temp4 proves that Call Date, which is the primary column is not a date, which is…
-
Formula for Filter: Not in the last (x) days
Hi, What formula gives me the same value as the above filter? Would need something like COUNT IF {Range 1} Is Not in the last (x) days Thank you!
-
Max Collect Formula
I am trying to use max collect to display the latest step in a project plan based on the highest value in the "project phase" column that has been marked as green in the "Status" column. I am returning a vlaue of 0 no matter what I try to change here. any thoughts? thanks!
-
Need Help with Formula for Metrics
Hi, I am stumped at a formula for this sheet. Please see picture below. I am trying to calculate an action taken goal where we take the levels standard, urgent, and immediate and the action taken days. The parameter is for standard 3 days, urgent 1 day, and immediate 0 days. I want in the action taken goal column the words…
-
Calculating time elapsed date and time
Hi all, I've read a few solutions on how to do this but just can't get my head around to apply it to my own sheet. I have an incident register that we are moving into smartsheet and one of the columns is duration of outage. In excel we have two columns; Incident start date + time and Incident end date + time (format…
-
Is there a better way to send notification if a cell has no update?
I have a file with two workflows. The first workflow is an update request which is sent on Thursday's. The other workflow is to notify the owner if a cell was not updated as requested. To trigger this workflow I created the following helper columns: Modified: auto number with date formula Modified date: date only from the…
-
I need a formula to calculate projected hours based on start/finish dates
In a project plan we have start date, finish date, and an estimated hours column to track against budgets. I need to be able to identify and total projected hours needed by month. Formula should return and absolute 36 hours for December - populating 20 and 16 in Dec column, 28 hours for January - populating 8 and 20 hours…
-
Count ifs formula
Hello, I'm using a smartsheet to track contacts engaged in a multi-year project. I'm trying to count all the contacts engaged in year 1 AND 2 in a sheet summary report and can't figure out how to countifs for this sheet. My column is called "year Engaged" and my fields say either "grant cycle #1" or "grant cycle #2". This…
-
help with a formula
Hi All picking your brain here on formulas cant make it work, I am looking to count if: In my column A the name is DC380 and if corresponding at the value in column A, the value in column B and C is "not done", see an example below: DC status A Status B DC480 approved not done DC280 approved not done DC380 approved not…