Formulas and Functions

Try this:<\/p>

=IF([Per Diem Eligible (Yes\/No)]@row = \"Yes\", [# Nights]@row * 25, \"//www.santa-greenland.com/community/categories/formulas-and-functions/\")<\/p>

Hope that helps!<\/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":[{"tagID":210,"urlcode":"Human Resources","name":"Human Resources"},{"tagID":215,"urlcode":"Templates","name":"Templates"},{"tagID":238,"urlcode":"Finance","name":"Finance"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":448,"urlcode":"workflows-in-smartsheet","name":"Workflows in Smartsheet"}]},{"discussionID":105688,"type":"question","name":"Adding a flag when im under?","excerpt":"I want on 1st Colum where says reorder flag, to automatically change to flag if last column \"Count yard\" is Under. Not sure if that's possible. Thanks!","categoryID":322,"dateInserted":"2023-05-25T14:38:52+00:00","dateUpdated":null,"dateLastComment":"2023-05-25T16:45:02+00:00","insertUserID":161791,"insertUser":{"userID":161791,"name":"Mdelacruz","url":"https:\/\/community.smartsheet.com\/profile\/Mdelacruz","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-05-25T17:07:23+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":161791,"lastUser":{"userID":161791,"name":"Mdelacruz","url":"https:\/\/community.smartsheet.com\/profile\/Mdelacruz","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-05-25T17:07:23+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":21,"score":null,"hot":3370059834,"url":"https:\/\/community.smartsheet.com\/discussion\/105688\/adding-a-flag-when-im-under","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/105688\/adding-a-flag-when-im-under","format":"Rich","lastPost":{"discussionID":105688,"commentID":377620,"name":"Re: Adding a flag when im under?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/377620#Comment_377620","dateInserted":"2023-05-25T16:45:02+00:00","insertUserID":161791,"insertUser":{"userID":161791,"name":"Mdelacruz","url":"https:\/\/community.smartsheet.com\/profile\/Mdelacruz","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-05-25T17:07:23+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\/6DMLZG6VOXCP\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-05-25T16:44:22+00:00","dateAnswered":"2023-05-25T14:40:48+00:00","acceptedAnswers":[{"commentID":377568,"body":"

Put this formula into your flag column:<\/p>

=IF([Count Status]@row=\"Under\",1,0)<\/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":105677,"type":"question","name":"Vlookup not working across sheets","excerpt":"Hey all. I'm trying to pull info from one sheet to another if two cells match and getting #INCORRECT ARGUMENT SET. Any help would be greatly appreciated! =VLOOKUP([Opportunity Name]@row, {PMO Capacity Opportunity Name}, 21, false)","categoryID":322,"dateInserted":"2023-05-24T21:20:52+00:00","dateUpdated":null,"dateLastComment":"2023-05-25T14:57:53+00:00","insertUserID":135865,"insertUser":{"userID":135865,"name":"Christy Kooiman","url":"https:\/\/community.smartsheet.com\/profile\/Christy%20Kooiman","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-05-25T14:56:24+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":135865,"lastUser":{"userID":135865,"name":"Christy Kooiman","url":"https:\/\/community.smartsheet.com\/profile\/Christy%20Kooiman","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-05-25T14:56:24+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":45,"score":null,"hot":3369992325,"url":"https:\/\/community.smartsheet.com\/discussion\/105677\/vlookup-not-working-across-sheets","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/105677\/vlookup-not-working-across-sheets","format":"Rich","lastPost":{"discussionID":105677,"commentID":377576,"name":"Re: Vlookup not working across sheets","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/377576#Comment_377576","dateInserted":"2023-05-25T14:57:53+00:00","insertUserID":135865,"insertUser":{"userID":135865,"name":"Christy Kooiman","url":"https:\/\/community.smartsheet.com\/profile\/Christy%20Kooiman","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-05-25T14:56:24+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,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-05-25T14:58:37+00:00","dateAnswered":"2023-05-25T14:39:41+00:00","acceptedAnswers":[{"commentID":377567,"body":"

I have discovered that index(collect seems to work much better when using cross sheet references as even if someone moves a column it still pulls in the data you want.<\/p>

=Index(Collect({PMO Capacity Opportunity Name},{PMO Capacity Opportunity Name},[Opportunity Name]@row),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":[]}],"title":"Trending in Formulas and Functions ","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">