I have client sheets that total time based on form entry, others that total expenses based on form entry. Summaries of these values are used in client reports.
I have new formulas with the help of Smartsheet support, that will make adding/editing formulas much more efficient than the various workarounds I've been doing. These new formulas seem to be working for one client where I only need to SUMIFS parents and children.
However, another client is more complicated and I can't seem to get the formula to work. There needs to be an additional criteria set for checking the value of column "Phase (I, II, FG or ST)"
GKC_Time_Columns_05Mar2019.png shows the columns I'm pulling data from (except the "Client Billable?" checkbox column.
GKC_Time_Formula_05Mar2019.png shows the formula pulled from the other client sheet but modified, not working.
GKC_Time_Data_05Mar2019.png shows two sample entries that should be summed.
GKC_Time_Result_05Mar2019.png shows the result. The cell at Jun 15, 2019, Row 4 should have a value of "1". Jun 15, 2019, Row 62 is correct for the Phase II entry using the old formula which is an incredibly labor intense update process with 180 formulas per column in this sheet alone.
I hope this makes sense and someone can point out where I need to modify the formula.