Formula help

Options

Hello- I'm trying to count number of times text shows in a column and it be a rolling qtr. the column name: "Management code key" and i want to count the number of times "communication" is mentioned. below is my current formula that I'm getting the #unparseable error. formula works without the rolling formula but it counts in all the rows but i need it to be rolling qtr.

=COUNTIF([Management Code Key]:[Management Code Key], FIND("Communication", @cell) > 0, AND([Created]:[Created]@cell >= IFERROR(DATE(YEAR(TODAY()), MONTH(TODAY()) - 3, 1), DATE(YEAR(TODAY()) - 1, MONTH(TODAY()) + 9, 1)), @cell < DATE(YEAR(TODAY()), MONTH(TODAY()), 1))))


TIA.

J

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!