Sales Pipeline Template

I downloaded this template, it consists of 3 sheets, Dashboard, Report and Sales Pipeline. The instruction PDF seems to indicate that the Sales Opportunity form, created within the Sales Pipeline sheet, is the method for getting Opportunities in to the Sales Pipeline.

Extract from ODF

The Sales Opportunity form is how sales reps submit information about leads to the Sales Pipeline sheet.

But when I complete the form and submit it the information is loaded in to the Report sheet, not the Sales Pipeline sheet. Am I doing something incorrect or does the information have to be loaded manually or the Report sheet linked to the Sales Pipeline sheet to load the data in to the Sales Pipeline sheet from the Report sheet.

John

Find more posts tagged with

Templates

Project Management

Comments

Andrée Starå

Hi John,

You are doing it correctly. If you can see the information in the report, then it's on the sheet because the report only shows what is on the sheet(s).

I think the issue is that the submission is placed in the lower part of the sheet because the rows between aren't empty. If you scroll to the bottom, the entry will probably be there.

Was I right?

Happy New Year!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

johng

Hi Andrée

Many thanks for your response, it is indeed further down the sheet. The rows appear empty but obviously 'something' (perhaps spaces) is in these rows.

Again many thanks for your assistance.

John

Andrée Starå

Happy to help!

Try deleting the "empty" rows.

Did that work?

Have a fantastic week!

Best,

Andrée

Sign in to join the conversation!

Quick Links

Trending discussions

How to Share Single Workspace Folder?
I have a workspace that I created with two subfolders. A user needs to have access to only one of them but when I have that folder selected, I can only share the entire workspace with them. Is there a secret way that I can share the parent folder and ensure that any new files created will be shared with the same people? I…
I have a Pro plan but I cannot create ANY reports
I have a Pro plan but I cannot create ANY reports. The system does not allow me to choose a folder, and consequently a sheet to create a row report and suggests an upgrade to Business or Enterprise. I'm quite new to Smartsheet and feel a bit disappointed with this limitation, or maybe I'm just doing something wrong. Alberto
Showing "stacked" data / Statuses of items by swimlane
I have multiple items that each have their own statuses and that roll up to "workstreams" or swimlanes. On the dashboard, I would like to show the progress of the items by swimlane without breaking it out into separate widgets for each. This would ideally be a stacked bar where each bar represented the Items and was broken…