Complex SUMIF/SUMIFS Issue
Hi - I am new to Smartsheet and I am trying to put a formula in that I have in a spreadsheet, but it appears Smartsheet is very different and I keep getting errors and not sure what to do. Here is the formula I have in the spreadsheet and would appreciate any help in converting this to Smartsheet language!
N2 = PROJECT STAGE
G2 = DATE PRIORITIZED
O2 = STAGE UPDATE DATE
I am trying to get the aging results from the date calculations in a fraction into a column 'AGE FROM PRIORITIZED DATE'. However, if the project is 'Implemented' or 'Closed', then instead of using the NOW portion of the formula, I am taking the 'STAGE UPDATE DATE (i.e. Date it was Implemented or Closed) against the Date Prioritized to determine how long it took to implement using fraction (i.e. 10 1/4 days).
Hopefully, this makes sense and someone can educate me on how to do this!
Help Article Resources
Check out the Formula Handbook template!