Need to get weekly data?


=COUNTIFS({New Hire/Replacements Range 7}, "EU", {New Hire/Replacements Range 1}, WORKDAY(TODAY(), 5))

Tried this formula but the result is zero which is wrong, can anyone please correct this?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!