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

Solution to manage accidental deletion
Good afternoon, Recently we have started one of our sheets in Card View and on a handful of occasions, we have had users deleting cards (or rows) from the sheet, simply by clicking the delete button on the keyboard by accident. I have done a manual test on a copy of the sheet and doing so does not prompt the user to ensure…
Submitting forms for approval
Any help would be greatly appreciated! We have a 3-step process for travel approvals. I am able to get the forms to the correct people. I now have a request for the ability to add comments during the approval process. Staff submit request via Smartsheet form Automation forwards the form to the manager for approval Once…
Why would an automation for movement not carry over a cell value?
Hi everyone, I’m running into an issue with one of my sheets and was hoping to see if anyone else has experienced this. Here’s the setup: I have a sheet where, when I check a box, the row moves to a “Completed” sheet. In my Total column, I use a formula that sums a group of cells tied together via a parent/child…