SUMIFS, cross-sheet reference based on dates.

edited 12/09/19 in Formulas and Functions

Sorry if this is a duplicate. I couldn't find an answer that fit my problem..

Formula: =SUMIFS({AccHours}, {ShipDate}, <=Date3, {completed}, <>"x")

All references are from another sheet except Date3. Date3 is a formula as well, which is TODAY()+2. This works in Excel, but doesn't seem to work here. I don't get an error, but instead I get zero. I still get zero even if I change the Date3 reference to a date instead of a formula. 




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!