I want to populate a Quote with information from a price list sheet

Is there a formula or functionality that would enable me to to create a quotation using data from a price list on a separate sheet ?

For instance on the price list sheet Column A ( SKU / Stock Code ) , Column B ( Description ) , Column C ( Unit Price ) .

I want to fill the SKU / Stock code into the quote and have the description and unit price auto populate ?

Find more posts tagged with

Sales

Finance

Formulas

Conditional Formatting

Accepted answers

All comments

Kelly Moore

Hey @Veshlin

Yes, you can do exactly as you desire. You will use a cross sheet formula to do this - you can see the link at the bottom for more information on creating the cross sheet reference. Since these are cross sheet references you cannot simply copy paste these formulas into your sheet

In your Description column on your Quote sheet

=INDEX({Price List sheet Description column}, MATCH([SKU / Stock code]@row, {Price List sheet SKU / Stock code column},0))

In your Price columns on your Quote sheet:

=INDEX({Price List sheet Unit Price column}, MATCH([SKU / Stock code]@row, {Price List sheet SKU / Stock code column},0))

Will these work for you?

Kelly

https://help.smartsheet.com/articles/2482644-create-cross-sheet-references

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.