Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Date in a CountIf formua

edited 12/09/19 in Archived 2017 Posts

I want a calculation that displays a summary of how many records have a complete date greater than or equal to 1/1/2017. 


Here is what I add to the cell:

="Unassigned: " + COUNTIFS(LOB:LOB, "ERx", [COMPLETE DATE]:[COMPLETE DATE], >=1/1/2017)


Then I get an "Invalid Operation" messag and SS adds spaces to the date portion of the formula:

="Unassigned: " + COUNTIFS(LOB:LOB, "ERx", [COMPLETE DATE]:[COMPLETE DATE], >=1 / 1 / 2017)




This discussion has been closed.