Hi I am trying to figure out how to count the number of times during the week that there is a revision to a project. The revisions are figured out by looking at the Estimate #. If the Estimate # has an "R" in them then I need the formula to count those. The current formula that I have is:

=COUNTIFS({Estimate#_Perspective_2020}, FIND("R", {Estimate#_Perspective_2020}, >0), {WeekNumber_Perspectives_2020}, WeekNumber@row)

This gives me an #INVALID DATA TYPE error.

See the screenshot below to see if you might be able to help me out.


Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!