"Link from cell in other sheet" is returning a "blank" - but the reference cell has info? what is h
Hello - This is a bit confounding, I have the links set up correctly and it returns a blank cell. I double check the source cell, and there is the correct information. Can anyone help?
Thanks
Answers
-
Jef Forward ✭✭✭
Sorry about my question - what is wrong that it wont return the information that is clearly in the source cell?
-
Andrée Starå ✭✭✭✭✭✭I hope you're well and safe!
Is it a busy sheet with many cross-sheet formulas, rows, or similar?
What happens if you log out/in and if you try in another browser?
I hope that helps!
Be safe, and have a fantastic week!
Best,
Andrée Starå| Workflow Consultant / CEO @WORK BOLD
✅我的订单st(s) help or answer your question or solve your problem? Please support the Community bymarking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå| Workflow Consultant / CEO @WORK BOLD
W:www.workbold.com| E:[email protected]| P: +46 (0) - 72 - 510 99 35
Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.
-
Jef Forward ✭✭✭
Hi Andre, Yes, It is a busy sheet. It is our main datasheet. I have logged in and out several times, and the same result between browser. At my wits end with this. Thanks, Jef
-
Emily Quick ✭✭
I am running into the same problem, was a solution found for this issue?
-
Alywilk ✭✭
嗨@Jef Forwardand@Emily QuickI was having this same issue today and found a way to resolve it on my own. When I linked, the cell turned up blank even though the source cell had data.
What worked for me was saving the sheet(with the blank link), then Removing the link from the cell, saving again and refreshing, then magically the number appeared however the link was gone so I re-added the link and it now reflects the number so SAVE. A bit of a hassle but hopefully it works for you.
Help Article Resources
Categories
If you're just wanting the month to compare to last (e.g. July today vs. June last), then this will do what you're after:<\/p>
=IF(AND(YEAR(Created@row) = YEAR(TODAY()), MONTH(Created@row) = (MONTH(TODAY())) - 1), 1)<\/p>
Hope this helps! 😊<\/span><\/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":254,"urlcode":"Formulas","name":"Formulas"}]},{"discussionID":107325,"type":"question","name":"Incorrect Argument Set","excerpt":"Hi All, I have a formula that worked in one row, but then when I make it a column formula, it shows \"incorrect argument set\" in all the other rows but the 1st one. Please see below: That's the formula: =IF(AND([CLIENT TYPE]@row = \"Platinum\", [TOTAL AGING]@row > 1), \"Red\", IF(AND([CLIENT TYPE]@row = \"Gold\", [REQUIRED…","snippet":"Hi All, I have a formula that worked in one row, but then when I make it a column formula, it shows \"incorrect argument set\" in all the other rows but the 1st one. Please see…","categoryID":322,"dateInserted":"2023-07-07T08:10:18+00:00","dateUpdated":null,"dateLastComment":"2023-07-07T10:46:00+00:00","insertUserID":158375,"insertUser":{"userID":158375,"name":"angelapaj","url":"https:\/\/community.smartsheet.com\/profile\/angelapaj","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!w4smdwuoBbo!BYfnwW-eMzI!G-HqZABFep4","dateLastActive":"2023-07-07T13:24:30+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"updateUserID":null,"lastUserID":158375,"lastUser":{"userID":158375,"name":"angelapaj","url":"https:\/\/community.smartsheet.com\/profile\/angelapaj","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!w4smdwuoBbo!BYfnwW-eMzI!G-HqZABFep4","dateLastActive":"2023-07-07T13:24:30+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":37,"score":null,"hot":3377445378,"url":"https:\/\/community.smartsheet.com\/discussion\/107325\/incorrect-argument-set","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107325\/incorrect-argument-set","format":"Rich","lastPost":{"discussionID":107325,"commentID":384125,"name":"Re: Incorrect Argument Set","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/384125#Comment_384125","dateInserted":"2023-07-07T10:46:00+00:00","insertUserID":158375,"insertUser":{"userID":158375,"name":"angelapaj","url":"https:\/\/community.smartsheet.com\/profile\/angelapaj","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!w4smdwuoBbo!BYfnwW-eMzI!G-HqZABFep4","dateLastActive":"2023-07-07T13:24:30+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,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/VE1CT9T9NVPK\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-07-07T10:44:50+00:00","dateAnswered":"2023-07-07T10:02:51+00:00","acceptedAnswers":[{"commentID":384119,"body":"
Can you try the formula below?<\/p>
=IF(AND([CLIENT TYPE]@row = \"Platinum\", [TOTAL AGING]@row > 1), \"Red\", IF(AND([CLIENT TYPE]@row = \"Gold\", [REQUIRED DATE]@row < TODAY(), [DRAWING STATUS]@row = \"Not Started\"), \"Red\", IF(AND([CLIENT TYPE]@row = \"Gold\", [REQUIRED DATE]@row < TODAY(), [DRAWING STATUS]@row = \"Review\"), \"Yellow\", IF(AND([CLIENT TYPE]@row = \"Silver\", [REQUIRED DATE]@row < TODAY(), [DRAWING STATUS]@row = \"Not Started\"), \"Yellow\", IF(AND([CLIENT TYPE]@row = \"Silver\", [REQUIRED DATE]@row < TODAY(), [DRAWING STATUS]@row = \"Review\"), \"Yellow\", \"Green\")))))\n<\/pre>"}]}},"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":107304,"type":"question","name":"Formula Help","excerpt":"Hi - I am trying to create a formula that shows the conditions of: Tasks due within the next 14 days that are not equal to the status of \"Complete\" or \"not Required\" I am looking to do this on as a summary total on the project sheet. Thank you for the help!","snippet":"Hi - I am trying to create a formula that shows the conditions of: Tasks due within the next 14 days that are not equal to the status of \"Complete\" or \"not Required\" I am looking…","categoryID":322,"dateInserted":"2023-07-06T19:40:25+00:00","dateUpdated":"2023-07-07T09:23:20+00:00","dateLastComment":"2023-07-07T13:26:13+00:00","insertUserID":163199,"insertUser":{"userID":163199,"name":"Kimberly Starasinich","title":"Senior Project Manager","url":"https:\/\/community.smartsheet.com\/profile\/Kimberly%20Starasinich","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!!nbb0n90hlLs!zku0MyLT07k!AB0neQYrId5","dateLastActive":"2023-07-07T13:31:26+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-07-07T13:25:52+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":44,"score":null,"hot":3377411798,"url":"https:\/\/community.smartsheet.com\/discussion\/107304\/formula-help","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107304\/formula-help","format":"Rich","tagIDs":[254,440],"lastPost":{"discussionID":107304,"commentID":384158,"name":"Re: Formula Help","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/384158#Comment_384158","dateInserted":"2023-07-07T13:26:13+00:00","insertUserID":45516,"insertUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-07-07T13:25:52+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-07-07T13:13:59+00:00","dateAnswered":"2023-07-07T13:09:38+00:00","acceptedAnswers":[{"commentID":384147,"body":"Give this a try:<\/p>
=COUNTIFS(Finish:Finish, @cell<= TODAY(14), Status:Status, AND(@cell <> \"Complete\", @cell <> \"Not Required\"))<\/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":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":440,"urlcode":"project-management","name":"Project Management"}]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&categoryID=322&includeChildCategories=1&type%5B0%5D=Question&excludeHiddenCategories=1&sort=-hot&limit=3&expand%5B0%5D=all&expand%5B1%5D=-body&expand%5B2%5D=insertUser&expand%5B3%5D=lastUser&status=accepted","prevURL":null,"currentPage":1,"total":10000,"limit":3},"title":"Trending in Formulas and Functions ","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">
