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.

LOOKUP documentation mismatch

J. Craig Williams
J. Craig Williams ✭✭✭✭✭✭
edited 12/09/19 inArchived 2016 Posts

The formula documentation:

http://help.smartsheet.com/articles/775363-using-formulas

gives these as the arguments:

LOOKUP(value, collection, return_column_index,collection_match)

while the Template for Formula examples gives these arguments:

LOOKUP(lookup_value, lookup_range, return_column_index, range_lookup)

第四个参数(馆藏n_match) is clear in the doc but unclear in the example (range_lookup -- when there is already a lookup_range)

Please update the example template to match the clearer documentation.

This request applies throughout the template example - if there is a reason for there to be a different naming convention in the examples than that of the doc, I would love to hear it.

Craig

Tags:
· Share on Facebook Share on Twitter

Comments

This discussion has been closed.

Categories

You will need to insert a system generated auto-number column (called \"Auto\" in this example) and then use a formula such as this:<\/p>

=[Part Mark]@row + IF(COUNTIFS([Part Mark]:[Part Mark], @cell = [Part Mark]@row, [Job #]:[Job #], @cell = [Job #]@row, Auto:Auto, @cell<= Auto@row)> 1, \"-\" + COUNTIFS([Part Mark]:[Part Mark], @cell = [Part Mark]@row, [Job #]:[Job #], @cell = [Job #]@row, Auto:Auto, @cell<= Auto@row), \"//www.santa-greenland.com/community/discussion/\")<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","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":104911,"type":"question","name":"PMO Template - Project Intake Sheet populates new projects when trying to use a pre-entered formula","excerpt":"I am using the PMO Template - Project Intake Sheet but have customized this to include new fields to score a project and a new column that calculates the project priority score. The issue I have is when drag down the formula to the blank rows (to calculate future projects) the sheet thinks I have entered a new project. Any…","categoryID":321,"dateInserted":"2023-05-05T22:11:56+00:00","dateUpdated":null,"dateLastComment":"2023-05-08T15:20:46+00:00","insertUserID":157582,"insertUser":{"userID":157582,"name":"JeffV","url":"https:\/\/community.smartsheet.com\/profile\/JeffV","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-05-08T15:21:17+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":8888,"lastUser":{"userID":8888,"name":"Andrée Starå","title":"Smartsheet Expert Consultant & Partner | Workflow Consultant \/ CEO @ WORK BOLD","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-05-08T23:26:07+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":8,"countViews":51,"score":null,"hot":3366888762,"url":"https:\/\/community.smartsheet.com\/discussion\/104911\/pmo-template-project-intake-sheet-populates-new-projects-when-trying-to-use-a-pre-entered-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/104911\/pmo-template-project-intake-sheet-populates-new-projects-when-trying-to-use-a-pre-entered-formula","format":"Rich","lastPost":{"discussionID":104911,"commentID":374777,"name":"Re: PMO Template - Project Intake Sheet populates new projects when trying to use a pre-entered formula","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/374777#Comment_374777","dateInserted":"2023-05-08T15:20:46+00:00","insertUserID":8888,"insertUser":{"userID":8888,"name":"Andrée Starå","title":"Smartsheet Expert Consultant & Partner | Workflow Consultant \/ CEO @ WORK BOLD","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-05-08T23:26:07+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Using Smartsheet","url":"https:\/\/community.smartsheet.com\/categories\/using-smartsheet"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/GCW1DVD7PT34\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-05-08T14:59:23+00:00","dateAnswered":"2023-05-08T14:44:15+00:00","acceptedAnswers":[{"commentID":374774,"body":"

@JeffV<\/a> <\/p>

You're more than welcome!<\/p>

Exactly, and it locks it down so nobody can change it.<\/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":104915,"type":"question","name":"% based on weight attributed to each column","excerpt":"I have 4 columns weighted as follows: 50% Academy 20% Together 20% self 10% Belieg I would like a formula such that when the percentage is added to the respective column, it provides an average based on the weigh of whats attributed to each column. Any help would be appreciated.","categoryID":321,"dateInserted":"2023-05-06T14:12:34+00:00","dateUpdated":null,"dateLastComment":"2023-05-06T20:50:48+00:00","insertUserID":137906,"insertUser":{"userID":137906,"name":"Vinton Douglas","url":"https:\/\/community.smartsheet.com\/profile\/Vinton%20Douglas","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-05-09T00:59:44+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":137906,"lastUser":{"userID":137906,"name":"Vinton Douglas","url":"https:\/\/community.smartsheet.com\/profile\/Vinton%20Douglas","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-05-09T00:59:44+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":42,"score":null,"hot":3366789802,"url":"https:\/\/community.smartsheet.com\/discussion\/104915\/based-on-weight-attributed-to-each-column","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/104915\/based-on-weight-attributed-to-each-column","format":"Rich","lastPost":{"discussionID":104915,"commentID":374719,"name":"Re: % based on weight attributed to each column","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/374719#Comment_374719","dateInserted":"2023-05-06T20:50:48+00:00","insertUserID":137906,"insertUser":{"userID":137906,"name":"Vinton Douglas","url":"https:\/\/community.smartsheet.com\/profile\/Vinton%20Douglas","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-05-09T00:59:44+00:00","banned":0,"punished":0,"private":false,"label":"✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Using Smartsheet","url":"https:\/\/community.smartsheet.com\/categories\/using-smartsheet"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-05-06T20:50:15+00:00","dateAnswered":"2023-05-06T17:06:09+00:00","acceptedAnswers":[{"commentID":374717,"body":"

Hey @Vinton Douglas<\/a> <\/p>

Try this<\/p>

=0.5*Academy@row+0.2*Together@row+0.2*self@row+0.1*Belieg@row <\/p>

Will this work for you?<\/p>

Kelly<\/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":[]}],"title":"Trending Posts","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">