Niraj -
Were you able to come up with a solution to this? If not, you can (sort of) accomplish this, but you will need to add more tables into your application to support it.
- You'll need a table for the Months and another table that would end up being a child to both the Months and Tasks.
- You would then need to generate records for this new table where each record represents one Month / Task combination.
- Create the Summary field(s) as necessary, such as Number of Checklists
- Create a Formula Rich Text field that would generate the Icon / image you're wanting to show on the report
- Create a Table report (not Summary) on the Month/Task table that shows the information as you're wanting it presented.
This is not the easiest solution and does have its drawbacks, but I've done this plenty of times for clients and it works like a charm.
------------------------------
Blake Harrison - DataBlender.io
Quick Base Solution Provider
------------------------------
