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
Can someone please help? I cannot figure out why this formula is not working.
Fyi..the Current Designation column is column number 2.
Comments
-
SmSulli ✭Stephanie,
I think a couple tips will help you out. Your selection for the look up table should include both the look up data columnandthe column with the return values you want in the Results. Also the look up data column must be the left most column of your selected columns.
Good Luck!
Shawn
-
Stephanie Taylor ✭✭✭✭✭✭
Unless I am misunderstanding you that is how I have the formula set up.
Never mind, I got it.
Thanks!
Categories
Looks like there needs to be a closing bracket for the YEAR function? Maybe try this?<\/p>
=IF(YEAR([Last Hire Date]@row) = \"2024\", (([Proration Date Reference]@row - [Last Hire Date]@row)\/365), \"1\")<\/p>
Note: you don't need the extra brackets around the 'If True' portion. The following should also work:<\/p>
=IF(YEAR([Last Hire Date]@row) = \"2024\", ([Proration Date Reference]@row - [Last Hire Date]@row)\/365, \"1\")<\/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":111618,"type":"question","name":"How to use IF function with AND OR","excerpt":"I am trying to establish a workflow based on the approval of several stakeholders. There are 8 stakeholders (contact column type) and not all will be required to review\/approve. If the stakeholders approve the change the project sponsor will be required to approve. I intend to have a workflow for each stakeholder to…","snippet":"I am trying to establish a workflow based on the approval of several stakeholders. There are 8 stakeholders (contact column type) and not all will be required to review\/approve.…","categoryID":322,"dateInserted":"2023-10-13T02:04:17+00:00","dateUpdated":null,"dateLastComment":"2023-10-13T04:57:08+00:00","insertUserID":168381,"insertUser":{"userID":168381,"name":"deej","title":"engineer","url":"https:\/\/community.smartsheet.com\/profile\/deej","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-10-13T04:46:37+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":168381,"lastUser":{"userID":168381,"name":"deej","title":"engineer","url":"https:\/\/community.smartsheet.com\/profile\/deej","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-10-13T04:46:37+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":19,"score":null,"hot":3394337485,"url":"https:\/\/community.smartsheet.com\/discussion\/111618\/how-to-use-if-function-with-and-or","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/111618\/how-to-use-if-function-with-and-or","format":"Rich","lastPost":{"discussionID":111618,"commentID":399817,"name":"Re: How to use IF function with AND OR","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/399817#Comment_399817","dateInserted":"2023-10-13T04:57:08+00:00","insertUserID":168381,"insertUser":{"userID":168381,"name":"deej","title":"engineer","url":"https:\/\/community.smartsheet.com\/profile\/deej","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-10-13T04:46:37+00:00","banned":0,"punished":0,"private":false,"label":"✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-10-13T08:17:16+00:00","dateAnswered":"2023-10-13T03:53:17+00:00","acceptedAnswers":[{"commentID":399810,"body":"
