How to Manage Pipeline in Salesforce: Review and Mass Update Deals

A Monday review found 1,346 open deals past their close date. See how to filter, flag and mass update them in one grid, step by step.
How to manage pipeline in Salesforce: a Valorx Wave grid of opportunities

To manage your pipeline in Salesforce, you need two things on the same screen: the deals that need attention, and a way to fix them. This guide follows the video. It filters to the overdue deals, flags them, and updates twelve of them in one save.

Jump to a chapter

What you'll build

  • One grid of your open deals, inside Salesforce
  • A filter for deals past their close date
  • A rule that highlights the late ones
  • A mass update you check before saving
  • No code and no admin ticket
  • Video length: 6 minutes

The review is solved. The fixing isn't.

Most teams already have this screen: the pipeline dashboard they walk every Monday. It shows which deals are stale, stuck or past their close date.

Salesforce sales executive dashboard used for the Monday pipeline review
The Monday view: a standard Salesforce sales dashboard. Demo data.

What the dashboard can't do is change a record. So after the review, somebody has to fix forty of them.

Fixing forty Salesforce records: open the record, change the date, save, back to the list
Open, change, save, back. Forty times. Or a spreadsheet, a ticket and a wait.

The standard path: one record at a time

To fix one close date from a list view, you open the record, find Close Date on the page, change it, save and go back. It isn't hard. It just doesn't get done when it's forty deals across six reps.

A Salesforce opportunity record page opened to change one close date
One deal, one record page. Demo data.
The usual wayIn a Wave grid
Open each record to change one close dateClick the cell in the grid and type
Collect the changes and file a ticket for a mass updateSelect the rows, change the field once, check it, save
Reps see a list, not what the review foundA rule highlights the late deals for everyone
Monday's pipeline isn't Friday's forecastThe fixes are saved during the review

Clean up the pipeline in five steps

Valorx Wave is a grid that runs inside Salesforce. Every record is a row and every field is a column, which is the one layout everybody already knows how to work.

Rows and columns: opportunities with stage, amount and close date in a grid
Click a cell and type. Select a range and change it once.
  1. Open the opportunities in a Wave grid. It's the same data as your list view, under your own profile, sharing rules and field-level security.
  2. Edit in place. Click a Close Date, pick a new date and press Enter. The cell is marked as changed but not saved. Make a few more edits and the Save button counts them.
Edited cells in a Valorx Wave grid waiting to be saved to Salesforce
Step 2. Changed cells wait in the grid until you save.
  1. Filter to what the review found. Open Filters and set Close Date before Today, and Stage none of Closed Won or Closed Lost.
Wave grid filtered to 1,346 open opportunities past their close date
Step 3. The filter returns 1,346 deals past their close date. Demo data.

The numbers from the video

One filter on our demo org shows how big the cleanup is.

Opportunities4,508
Still open3,940
Open and past close date1,346
  1. Add a rule so late deals stand out. In Rules, add one called Overdue: when Close Date is before today, highlight the row. The rule is saved with the view, so reps see what the review saw.
  2. Mass update with Mass Modifier. Select the rows, open Mass Modifier, pick Close Date and the new date, and apply. Every selected cell is marked as pending, so you can check each one first.
Mass Modifier in Valorx Wave setting a new close date on selected opportunities
Step 5. Mass Modifier: pick the field, set the value, apply.
Twelve selected opportunities with new close dates and a Save 12 changes button
Twelve deals moved to the end of the month. The button reads "Save 12 changes".

Your validation rules and required fields still apply. Wave writes through the same Salesforce layer as any other save.

Questions this video answers

How do you manage pipeline in Salesforce?

Keep every open opportunity current: stage, amount, close date, forecast category and next step. Salesforce gives you list views, reports and dashboards to review the pipeline. The updates are made on each opportunity record, or across many records at once in a grid.

How do I find open deals that are past their close date?

Filter opportunities where Close Date is before today and Stage is not Closed Won or Closed Lost. The count at the bottom of the grid tells you how big the cleanup is.

How do I mass update opportunities in Salesforce?

In a Wave grid, select the rows, open Mass Modifier, pick the field and the new value, check the pending cells, and save once. More ways to do it: How to mass update records in Salesforce.

Does a grid get around our validation rules or permissions?

No. Wave runs inside Salesforce under each user's profile, sharing rules and field-level security. If a rep can't see a field in Salesforce, they won't see it in the grid.

Keep going

Recorded in a Salesforce demo org with demo data. Every changed record was backed up first and restored after recording.

Want to see it on your own pipeline? Book a demo and we'll build the first grid with you on the call.