Count status -Close,Rejected,Open by month, year

HZAR · 03/21/24

Hi

I am quite new to Smartsheet. I have attached the input and desired output that I need. Thanks and really appreciate it

Paul Newcome · 03/21/24

I would suggest the opposite structure for your table data. Use a date type column with the first of each month that you want to track for entered, and use separate columns for each status.

Then your formula would look along the lines of

=COUNTIFS({Source Sheet Status Column}, @cell = "Open", {Source Sheet Date Column}, AND(IFERROR(MONTH(@cell), 0) = MONTH([Date Column]@row), IFERROR(YEAR(@cell), 0) = YEAR([Date Column]@row)))

Paul Newcome · 03/21/24

I would suggest the opposite structure for your table data. Use a date type column with the first of each month that you want to track for entered, and use separate columns for each status.

Then your formula would look along the lines of

=COUNTIFS({Source Sheet Status Column}, @cell = "Open", {Source Sheet Date Column}, AND(IFERROR(MONTH(@cell), 0) = MONTH([Date Column]@row), IFERROR(YEAR(@cell), 0) = YEAR([Date Column]@row)))

HZAR · 04/15/24

Hi Paul

Thanks for the help. It works now. Really appreciate your help in this.

Count status -Close,Rejected,Open by month, year

Best Answer

Answers

Help Article Resources

Categories