Adjust your personal account settings<\/a><\/p>Let me know if this helped! If not, it may be useful to see screen captures showing the areas where you see discrepancies, but please block out sensitive data. <\/p>
Thanks,<\/p>
Genevieve<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-10-06 18:47:09","updateUser":{"userID":145028,"name":"DesireeJones","url":"https:\/\/community.smartsheet.com\/profile\/DesireeJones","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-06T19:24:52+00:00","banned":0,"punished":0,"private":false,"label":"✭"}}},"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":[{"tagID":204,"urlcode":"Forms","name":"Forms"}]},{"discussionID":96277,"type":"question","name":"Trying to yield results only if a date is in between two dates","excerpt":"=IF([Q1 End Date]1 > [Target Service Start Date]6 < [Q1 Start Date]1, \"true\", \"false\") This is the formula I tried. =IF([Target Service Start Date]6 <[Q1 End Date]1 > [Q1 Start Date]1, \"true\", \"false\") I also tried this.. still not working. I am trying to say if [Target Service Start Date] falls between [Q1 Start Date] and…","categoryID":321,"dateInserted":"2022-10-05T21:02:07+00:00","dateUpdated":null,"dateLastComment":"2022-10-06T19:36:43+00:00","insertUserID":152884,"insertUser":{"userID":152884,"name":"mtetzlaf","url":"https:\/\/community.smartsheet.com\/profile\/mtetzlaf","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-06T21:06:48+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":67611,"lastUser":{"userID":67611,"name":"Michael Culley","url":"https:\/\/community.smartsheet.com\/profile\/Michael%20Culley","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/9BX019BZTFOW\/n0CCMUI3GCT23.jpg","dateLastActive":"2022-10-06T21:53:12+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":28,"score":null,"hot":3330091730,"url":"https:\/\/community.smartsheet.com\/discussion\/96277\/trying-to-yield-results-only-if-a-date-is-in-between-two-dates","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/96277\/trying-to-yield-results-only-if-a-date-is-in-between-two-dates","format":"Rich","lastPost":{"discussionID":96277,"commentID":346353,"name":"Re: Trying to yield results only if a date is in between two dates","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/346353#Comment_346353","dateInserted":"2022-10-06T19:36:43+00:00","insertUserID":67611,"insertUser":{"userID":67611,"name":"Michael Culley","url":"https:\/\/community.smartsheet.com\/profile\/Michael%20Culley","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/9BX019BZTFOW\/n0CCMUI3GCT23.jpg","dateLastActive":"2022-10-06T21:53:12+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":"2022-10-06T19:28:23+00:00","dateAnswered":"2022-10-06T13:26:13+00:00","acceptedAnswers":[{"commentID":346256,"body":"
Try this:<\/p>
=IF(AND([Target Service Start Date]6 <[Q1 End Date]1,[Target Service Start Date]6 > [Q1 Start Date]1), \"true\", \"false\")<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-10-06 19:28:24","updateUser":{"userID":150538,"name":"Preston P.","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Preston%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/avatarstock\/nWVKDFTEFOKBN.png","dateLastActive":"2022-10-06T22:28:36+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"}}},"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":96269,"type":"question","name":"Format main item in project","excerpt":"Hello, Hoping to get help with the following: Currently using Conditional formatting for \"status\" column to row highlight and use strike through of entire row when marked \"Complete\" However, it doesn't mark the main \"unindented\" item header. I originally planned to manually mark it complete but with my tracking that I'm…","categoryID":321,"dateInserted":"2022-10-05T17:55:41+00:00","dateUpdated":"2022-10-05T18:15:17+00:00","dateLastComment":"2022-10-06T21:05:06+00:00","insertUserID":152278,"insertUser":{"userID":152278,"name":"Morris R","url":"https:\/\/community.smartsheet.com\/profile\/Morris%20R","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-06T21:04:39+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"lastUserID":152278,"lastUser":{"userID":152278,"name":"Morris R","url":"https:\/\/community.smartsheet.com\/profile\/Morris%20R","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-06T21:04:39+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":34,"score":null,"hot":3330084047,"url":"https:\/\/community.smartsheet.com\/discussion\/96269\/format-main-item-in-project","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/96269\/format-main-item-in-project","format":"Rich","lastPost":{"discussionID":96269,"commentID":346377,"name":"Re: Format main item in project","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/346377#Comment_346377","dateInserted":"2022-10-06T21:05:06+00:00","insertUserID":152278,"insertUser":{"userID":152278,"name":"Morris R","url":"https:\/\/community.smartsheet.com\/profile\/Morris%20R","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-06T21:04:39+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,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/JINZ0PK153W5\/screen-shot-2022-10-05-at-1-47-31-pm.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Screen Shot 2022-10-05 at 1.47.31 PM.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2022-10-06T21:05:12+00:00","dateAnswered":"2022-10-05T18:51:51+00:00","acceptedAnswers":[{"commentID":346147,"body":"
I would create a helper column like a checkbox column.<\/p>
In that column I would do something like this:<\/p>
=IFERROR(IF(COUNTIF(CHILDREN([Status]@row), \"complete\") \/ COUNT(CHILDREN([Project]@row)) = 1, 1, 0), 0)<\/p>
Then do a conditional format where if the helper column is checked, do the strike through to the Project cell.<\/p>
Hope that helps.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-10-06 21:05:12","updateUser":{"userID":152278,"name":"Morris R","url":"https:\/\/community.smartsheet.com\/profile\/Morris%20R","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-06T21:04:39+00:00","banned":0,"punished":0,"private":false,"label":"✭"}}},"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 in Using Smartsheet","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">