I wish to compare a particular date in formula itself.

For eg - =IF($[Date1]@row > "1/4/2020", COUNT($[Date2]@row, "B")

Right now my approach is updating the formula column properties as Date and updating 1st row as "1/4/2020" then comparing this with Date1. Issue with this is that the rest of the values in this column should be date or any string only. I want to add numeric values.

My approach eg - IF($[Date1]@row > [Apr 2019]$1, COUNT($[Date2]@row, "B")

I am getting error as #DATE EXPECTED.

Thanks in advance!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!