How to Compare Values of Two Columns Right in the List

Tips
Published 11. 5. 2021

DID YOU KNOW...

 

...that in eWay-CRM you can compare values ​​of two columns right in the list of projects, deals, etc.? This way, you can eg. compare estimated and actual profit of projects. You can filter projects to see only those that has higher (or lower) estimated profit than the actual. Or you can highlight such projects in color using conditional formatting.

 

Option 1 - Filtering

  1. In the list of projects, right-click on the Estimated Profit column and select Filter Editor.
  2. In the editor, select Actual Profit as the second value to compare and select the operator - Is greater than or Is Less Than.
  3. Confirm with OK. In the list of projects you will see only projects with higher or lower actual profit than the estimated (depending on which operator you have chosen).

Option 2 - Conditional Formatting

  1. In the list of projects, right-click the Estimated Profit column, hover over the Conditional Formatting menu, and select Manage Rules.
  2. In the rules manager, click New Rule. In the window for creating a new rule, select the Use a formula to determine which cells to format option.
  3. In the editor, select Actual Profit as the second value to compare and select the operator - Is greater than or Is Less Than.
  4. Click the Format button to set the cell format. Set your own format or choose from the drop-down menu under the Predefined Appearence tab. Confirm the cell format settings with the OK button, and then click OK in the window to create a new rule.
  5. Activate the new rule by checking the checkbox below the Apply to the row column and confirm again by clicking OK.

 

For more advanced tips, go to our Knowledge Base.

Be effective! With eWay-CRM.

 

Choose from the following modules

Contact

Contacts & Companies

Core module everybody starts with. Allows you to work with contacts, and companies, track communications and plan follow-ups.

Sales

Sales

Ads the ability to track deals, create quotes and invoices, and manage pricing and inventories.

Project

Projects

Great if you need to coordinate the delivery once you sign a contract. Manage resources, track timesheets, and keep an eye on the budget.

Marketing

Email Marketing

Extends your eWay-CRM of a professional email marketing tool. No limitations on the number of contacts. Charged by emails sent.

Complete comparison table