@mistone<\/a> <\/p>Form entries cannot land in the same row. However, you could use a form entry to check out and then use an update request to check in. <\/p>
Hope this helps!<\/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":108408,"type":"question","name":"Formula to check if a cell contains \"No\" or isblank","excerpt":"This is probably so simple but I am struggling with my if and isblank, or maybe I don't need isblank and need just \"//www.santa-greenland.com/community/discussion/5582/\" empty quotes. The Column title is \"Added to CRM\" and it can contain Yes, No, Revised or blank. I would like to check a cell and if it contains either the word \"No\" or is blank return a phrase like \"Open\".…","snippet":"This is probably so simple but I am struggling with my if and isblank, or maybe I don't need isblank and need just \"//www.santa-greenland.com/community/discussion/5582/\" empty quotes. The Column title is \"Added to CRM\" and it can…","categoryID":322,"dateInserted":"2023-08-02T13:17:51+00:00","dateUpdated":"2023-08-02T13:20:09+00:00","dateLastComment":"2023-08-02T14:15:32+00:00","insertUserID":160184,"insertUser":{"userID":160184,"name":"Christina C","title":"Project Coordinator","url":"https:\/\/community.smartsheet.com\/profile\/Christina%20C","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-02T14:16:25+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":160184,"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-08-02T18:59:20+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":36,"score":null,"hot":3381969803,"url":"https:\/\/community.smartsheet.com\/discussion\/108408\/formula-to-check-if-a-cell-contains-no-or-isblank","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/108408\/formula-to-check-if-a-cell-contains-no-or-isblank","format":"Rich","lastPost":{"discussionID":108408,"commentID":388476,"name":"Re: Formula to check if a cell contains \"No\" or isblank","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/388476#Comment_388476","dateInserted":"2023-08-02T14:15:32+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-08-02T18:59:20+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-08-02T13:28:35+00:00","dateAnswered":"2023-08-02T13:21:35+00:00","acceptedAnswers":[{"commentID":388463,"body":"
Try this:<\/p>
=IF(OR([Added to CRM]@row = \"No\", [Added to CRM]@row = \"//www.santa-greenland.com/community/discussion/5582/\"), \"Open\")<\/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":[]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&includeChildCategories=1&type%5B0%5D=Question&excludeHiddenCategories=1&siteSectionID=0&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 Posts","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">
Trending Posts
Row Report from Sheets in Workspace 如果我有一组folders under a workspace with different type sheets. Some will be Project plans, others may be RAID/CRAID Logs, etc. Is there a way to create a row report of all the RAID/CRAID Logs only, and separate from a similar row report with all the Project Plan line items?
Creating Check out/in sheet and form? Is it possible to create a check out/in sheet and form where the entries from the form will land on the same row? I want to create a form where people can check things out/in on the same date. So I'd check things out the in the morning of 8/2 and check them in at closing time. I want all the data to land on the same row so…
Formula to check if a cell contains "No" or isblank This is probably so simple but I am struggling with my if and isblank, or maybe I don't need isblank and need just "" empty quotes. The Column title is "Added to CRM" and it can contain Yes, No, Revised or blank. I would like to check a cell and if it contains either the word "No" or is blank return a phrase like "Open".…