If you have several open stages in your sales pipeline, it can be useful to group them into a single status so you can quickly report on how many deals are Open, Won, and Lost.
A simple way to do this is by creating a Deal Status formula attribute. Instead of reporting on every individual pipeline stage, the formula maps multiple stages into one of three high-level values.
In my example:
This gives you a much cleaner attribute for filtering, reporting, and building dashboards without having to account for every individual stage in your pipeline.
Technically, you could simplify this even further by checking whether the stage has any value that isn't Won or Lost, and returning "Open". I've listed out each of my active stages explicitly here because I find it a little easier to read and maintain.
Once you've created your Deal Status formula attribute, you can use it to build a simple insight report that gives you an instant overview of your pipeline.
Create a new Insight report using Deals as the data source, set the metric to Count Records, then group the report by your Deal Status formula attribute. This will automatically group every deal into Open, Won, or Lost, giving you a much cleaner snapshot than reporting on every individual pipeline stage.
In the example below, I've added an advanced filter to only include deals created in the last 30 days.
This lets you focus on recent pipeline activity instead of reporting across your entire deal history.
You can take this a step further by using the Segment by option. For example, segmenting by Deal Owner lets you compare each rep's pipeline, showing how many of their deals are currently open, won, or lost. You could also segment by attributes such as Deal Value, Deal Size, or any other deal attribute to break down your pipeline from different perspectives.
Although this is a simple example, formula attributes can make reporting much more meaningful by transforming detailed CRM data into something easier to analyse. Whether you're tracking pipeline health, building dashboards, or creating filtered views, a small formula like this can make it much quicker to understand what's happening in your sales pipeline at a glance.