TODAY function NOT working.

Options
AshleeEBI
AshleeEBI ✭✭
edited 05/16/23 in Formulas and Functions

Hi All,

Someone help me with this.

I have 4 columns, TODAY, THIS WEEK, LAST WEEK and THIS MONTH…

I am trying to count all the rows in a certain sheet that are THIS WEEK and marked "Ordered".

=COUNTIFS({INTAKE SHEET 1 DATE}, TODAY(7), {INTAKE SHEET 1 STATUS}, HAS(@cell, "Ordered"))

My issue - this formula (when changing the parameters) is working for ALL my other columns except this week. So for last week I have the -7 in the today column, in the today it is blank just the ().

Why is it NOT working for this week? It pulls 0 results in.. and I AM LOST. Please help..

Thanks in advance!

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!