Total Amount of Rejections Created Last Week

Pam Ferguson
Pam Ferguson Overachievers Alumni

Help!!!! I can't figure out where the problem is with my formula. I am trying to write a formula to calculate the total $ amount of rejections from last week. This is what I have. It comes up with an Incorrect Arugument.

@Paul Newcome can you help?, please...... πŸ˜€

=IF(WEEKNUMBER(TODAY()) = 1, SUMIFS({Rejection Tracker Total Billed A/R}, IFERROR(WEEKNUMBER(@cell), 0) = 52, {Rejection Tracker Date Added to Report}, IFERROR(YEAR(@cell), 0) = YEAR(TODAY()) - 1), SUMIFS({Rejection Tracker Total Billed A/R}, IFERROR(WEEKNUMBER(@cell), 0) = WEEKNUMBER(TODAY()) - 1, {Rejection Tracker Date Added to Report}, IFERROR(YEAR(@cell), 0) = YEAR(TODAY())))

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!