Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, pleaseVisit the Current Forums.
Report Builder
I would like to build a report from two sheets that uses the same number to identify items and fills the columns in that correspondes witht that number.
For example- Take the UPC of one item and grab the revision date from one smartsheet and the backstock quantity from another smartsheet.
I looked through help articles and forum questions, but haven't found the answer.
Comments
-
Brett Evans ✭✭✭✭✭✭
Megan,
This is not currently available in Smartsheet, but is on the roadmap, hopefully soon. You are loking fo a VLOOKUP function.
As a work around you can build a report that sorts by UPC number. Then the Data would be on concurrent rows.
-Brett
-
You can usecell linkingto bring in information on a product from multiple sheets. This would need to be set up manually for each item but it would get the results you are looking for.
Categories
<\/p>
Current options are only to take screenshot or print the dashboard as a PDF or to One Note. However, there already is a planned enhancement in the roadmap to send the dashboard snapshot via a scheduled email (similar to reports). No timelines have been mentioned as yet.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[]},{"discussionID":107021,"type":"question","name":"Formula for %","excerpt":"Im looking for a formula to return the percentage that our projects are over\/under.","snippet":"Im looking for a formula to return the percentage that our projects are over\/under.","categoryID":322,"dateInserted":"2023-06-28T15:05:06+00:00","dateUpdated":null,"dateLastComment":"2023-06-29T02:08:33+00:00","insertUserID":161805,"insertUser":{"userID":161805,"name":"TPALJA","title":"Scheduler","url":"https:\/\/community.smartsheet.com\/profile\/TPALJA","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!2UcnvvuysSo!!7FqQoFuT_Rw","dateLastActive":"2023-06-29T02:06:47+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":161805,"lastUser":{"userID":161805,"name":"TPALJA","title":"Scheduler","url":"https:\/\/community.smartsheet.com\/profile\/TPALJA","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!2UcnvvuysSo!!7FqQoFuT_Rw","dateLastActive":"2023-06-29T02:06:47+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":30,"score":null,"hot":3375970419,"url":"https:\/\/community.smartsheet.com\/discussion\/107021\/formula-for","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107021\/formula-for","format":"Rich","tagIDs":[254],"lastPost":{"discussionID":107021,"commentID":382987,"name":"Re: Formula for %","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/382987#Comment_382987","dateInserted":"2023-06-29T02:08:33+00:00","insertUserID":161805,"insertUser":{"userID":161805,"name":"TPALJA","title":"Scheduler","url":"https:\/\/community.smartsheet.com\/profile\/TPALJA","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!2UcnvvuysSo!!7FqQoFuT_Rw","dateLastActive":"2023-06-29T02:06:47+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/O3NPEPI0XAMQ\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-29T02:07:09+00:00","dateAnswered":"2023-06-28T15:32:28+00:00","acceptedAnswers":[{"commentID":382861,"body":"
If you want to know the percentage over\/under the Contract Amount<\/strong>, your formula (placed the [Percentage] column) would be:<\/p> =([Contract amount]@row - [Install Labor (actual)]@row) \/ [Contract amount]@row<\/p> Be sure the \"Percentage\" column is formatted as a percentage. Positive numbers show that your total spend is under<\/strong> the [Contract amount]. Negative values show your total spend is over<\/strong>.<\/p> You can use a similar formula to measure how far over\/under your [Labor $ (quoted)] amount is from your [Install Labor (actual)] amount.<\/p> =([Labor $ (quoted)]@row - [Install Labor (actual)]@row) \/ [Labor $ (quoted)]@row<\/p> Here, though, a negative value shows that you are OVER<\/strong> the estimate. A positive value shows you are at or UNDER<\/strong> the estimate.<\/p>
![\"Screenshot](\"https:\/\/us.v-cdn.net\/6031209\/uploads\/FTR07ISR2LWW\/screenshot-2023-06-28-at-8-31-35-am.png\")
<\/img><\/a>\n <\/div>\n<\/div>\n
