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.
Need formula to count rows with a text character in a number string, within a date range
I would like to write a formula to count how many times a text character appears in a number string, within a specific week of the year. My JOB # column contains many project numbers (63254C, 63255C, 3235M, 63256C, 3236M... etc.). I would like to know how many "C" characters I have in that column, and how many "M" characters I have in the column. I also need to count them in correspondence to a week of the year. I have this formula labeling my weeks for the date when I start a project:
IF(AND([PM Start Date]144 >= DATE(2017, 6, 5), [PM Start Date]144 <= DATE(2017, 6, 11)), "W23"
Now, I'd like to count how many rows have a "C" int he JOB # column, and also have "W23" in that row.
Any idea how I can accomplish this?