@dhawkins<\/a> Try the formula below and let me know if that works. The AND function is a comma separated list of conditions, and always returns only True or False. <\/p>=IF(AND([Build Approved]@row = 1, [Install Complete]@row = 1, [In Production]@row = 1), \"In Production\", IF(AND([Build Approved]@row = 1, [Install Complete]@row = 1, [In Production]@row = 0), \"Installed\", IF(AND([Build Approved]@row = 1, [Install Complete]@row = 0, [In Production]@row = 0), \"Build Approved\", \"Design\")))<\/p>"},{"commentID":379709,"body":"
=IF([Build Approved]@row = 0, \"Design\", IF([Install Complete]@row = 0, \"Build Approved\", IF([In Production]@row = 0, \"Installed\", \"In Production\")))<\/p>
This may work.<\/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":106232,"type":"question","name":"Check if project start\/end dates fall within specific time frame.","excerpt":"My team works on projects that typically take 6-12 months. I'd like to create a roll-up sheet that identifies which quarters in which a project was worked on. I'm creating a new row for each project and linking in the start and end dates from each of the projects' sheets. Then I've created a new column for each quarter…","categoryID":322,"dateInserted":"2023-06-08T19:44:47+00:00","dateUpdated":"2023-06-08T19:49:54+00:00","dateLastComment":"2023-06-08T20:08:51+00:00","insertUserID":161563,"insertUser":{"userID":161563,"name":"gunnell","title":"Director, eLearning Initiatives","url":"https:\/\/community.smartsheet.com\/profile\/gunnell","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-08T20:05:56+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":161563,"lastUserID":161563,"lastUser":{"userID":161563,"name":"gunnell","title":"Director, eLearning Initiatives","url":"https:\/\/community.smartsheet.com\/profile\/gunnell","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-08T20:05:56+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":15,"score":null,"hot":3372509018,"url":"https:\/\/community.smartsheet.com\/discussion\/106232\/check-if-project-start-end-dates-fall-within-specific-time-frame","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106232\/check-if-project-start-end-dates-fall-within-specific-time-frame","format":"Rich","lastPost":{"discussionID":106232,"commentID":379713,"name":"Re: Check if project start\/end dates fall within specific time frame.","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/379713#Comment_379713","dateInserted":"2023-06-08T20:08:51+00:00","insertUserID":161563,"insertUser":{"userID":161563,"name":"gunnell","title":"Director, eLearning Initiatives","url":"https:\/\/community.smartsheet.com\/profile\/gunnell","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-08T20:05:56+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-06-08T20:09:01+00:00","dateAnswered":"2023-06-08T20:08:51+00:00","acceptedAnswers":[{"commentID":379713,"body":"
Answered my own question! Well, sort of... I remembered that ChatGPT knows how to code and ask it... I got it working right away. Thanks ChatGPT!<\/p>
This will check for 2022Q1:<\/p>
=IF(OR(<\/strong>AND($Start@row >= DATE(2022, 1, 1), $Start@row <= DATE(2022, 3, 31)), AND($End@row >= DATE(2022, 1, 1), $End@row <= DATE(2022, 3, 31)))<\/strong>, \"Overlap\", \"No Overlap\")<\/p>I thought I'd just post this rather than deleting the original post now that I have an answer.<\/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":106217,"type":"question","name":"Dynamic View- using multiple contact columns to restrict access","excerpt":"I have a dynamic view that used to give access based on two columns (if you were in the Contact or Back Up Contact - you could see that row). On Tuesday this functionality was no longer working (the page would not load for anyone) and I went in to fix it and had to select the restriction just on one contact column- I…","categoryID":321,"dateInserted":"2023-06-08T17:25:00+00:00","dateUpdated":null,"dateLastComment":"2023-06-08T18:04:40+00:00","insertUserID":135050,"insertUser":{"userID":135050,"name":"Kernesa Samana","url":"https:\/\/community.smartsheet.com\/profile\/Kernesa%20Samana","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!HhtBX2V_lvQ!ujlE5-cskro!7uS1l0rsYem","dateLastActive":"2023-06-08T18:29:55+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"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-06-08T18:05:48+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":23,"score":null,"hot":3372493180,"url":"https:\/\/community.smartsheet.com\/discussion\/106217\/dynamic-view-using-multiple-contact-columns-to-restrict-access","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106217\/dynamic-view-using-multiple-contact-columns-to-restrict-access","format":"Rich","lastPost":{"discussionID":106217,"commentID":379680,"name":"Re: Dynamic View- using multiple contact columns to restrict access","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/379680#Comment_379680","dateInserted":"2023-06-08T18:04:40+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-06-08T18:05:48+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-06-08T18:33:36+00:00","dateAnswered":"2023-06-08T18:04:40+00:00","acceptedAnswers":[{"commentID":379680,"body":"
Apply a filter to the sheet and then you can select that filter in the Dynamic View.<\/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":[]}">
扎克年代 员工
