\n
<\/img><\/a>\n <\/div>\n<\/div>\nI have exposed the formula I have used in the last column to show how the Max per Value is coming through.<\/p>
I know this has simplified your original question, but can you see how the Max(Collect()) statement works here?<\/p>
Does this help at all?<\/p>
So in yours: <\/p>
=MAX(COLLECT({CQ Hours Data Range 6}, {CQ Hours Data Range 2}, Model@row, {CQ Hours Data Range 5}, Batch@row),<\/strong>)<\/p>
Range 6 and the column you have written this formula into must be Date fields and you have an extra comma where you don't need it! Just between the last two )). This comma will cause an error.<\/p>
Kind regards<\/p>
Debbie<\/p>"},{"commentID":386369,"body":"
Hello Debbie,<\/p>
Appreciate your help, that worked perfectly!<\/p>
Thank you!<\/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":107881,"type":"question","name":"Formula to show duration days in Months, Weeks, and Days","excerpt":"I have a duration in days column and I need to show what that duration is in months, weeks and days. Assuming a month is 30 days and a week is 7 days. The attached blue columns are what I want to calculate with a formula (manually entered now to show what I want to see). For example, if something is 38 days, I want it to…","snippet":"I have a duration in days column and I need to show what that duration is in months, weeks and days. Assuming a month is 30 days and a week is 7 days. The attached blue columns…","categoryID":322,"dateInserted":"2023-07-20T19:40:32+00:00","dateUpdated":"2023-07-20T19:41:46+00:00","dateLastComment":"2023-07-21T12:14:38+00:00","insertUserID":139118,"insertUser":{"userID":139118,"name":"Kayla","url":"https:\/\/community.smartsheet.com\/profile\/Kayla","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!w4jS9-j6AyQ!-s9Rt9CEFHw!9QXda4h64Go","dateLastActive":"2023-07-21T12:44:11+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":139118,"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-21T12:47:44+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":35,"score":null,"hot":3379825510,"url":"https:\/\/community.smartsheet.com\/discussion\/107881\/formula-to-show-duration-days-in-months-weeks-and-days","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107881\/formula-to-show-duration-days-in-months-weeks-and-days","format":"Rich","tagIDs":[219,254,324],"lastPost":{"discussionID":107881,"commentID":386370,"name":"Re: Formula to show duration days in Months, Weeks, and Days","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/386370#Comment_386370","dateInserted":"2023-07-21T12:14:38+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-21T12:47:44+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\/E719S9G7QZCH\/example.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Example.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-07-21T00:25:23+00:00","dateAnswered":"2023-07-20T20:20:50+00:00","acceptedAnswers":[{"commentID":386281,"body":"
Try something like this...<\/p>
<\/p>
Months:<\/p>
=INT([Duration Days]@row \/ 30)<\/p>
<\/p>
Weeks:<\/p>
=INT(([Duration Days]@row - (Months@row * 30)) \/ 7)<\/p>
<\/p>
Days:<\/p>
=[Duration Days]@row - ((Weeks@row * 7) + (Months@row * 30))<\/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":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":324,"urlcode":"community-platform","name":"Community Platform"}]},{"discussionID":107861,"type":"question","name":"Can I trigger an event when selecting a value from a dropdown list?","excerpt":"Dear all, I have a column with a dropdown list. At the beginning of a project, the value for each dropdown\/task is set to \"Not started\". As soon as the vale for the first task changes, I would like to change another field's value ([Start Date]1) to today's date. But only if it didn't contain a value yet, so I can use it to…","snippet":"Dear all, I have a column with a dropdown list. At the beginning of a project, the value for each dropdown\/task is set to \"Not started\". As soon as the vale for the first task…","categoryID":322,"dateInserted":"2023-07-20T15:52:09+00:00","dateUpdated":null,"dateLastComment":"2023-07-21T12:21:11+00:00","insertUserID":161446,"insertUser":{"userID":161446,"name":"MarkFX","url":"https:\/\/community.smartsheet.com\/profile\/MarkFX","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-21T09:39:22+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-07-21T12:47:44+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":16,"countViews":44,"score":null,"hot":3379820000,"url":"https:\/\/community.smartsheet.com\/discussion\/107861\/can-i-trigger-an-event-when-selecting-a-value-from-a-dropdown-list","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107861\/can-i-trigger-an-event-when-selecting-a-value-from-a-dropdown-list","format":"Rich","lastPost":{"discussionID":107861,"commentID":386372,"name":"Re: Can I trigger an event when selecting a value from a dropdown list?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/386372#Comment_386372","dateInserted":"2023-07-21T12:21:11+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-21T12:47:44+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-21T09:39:50+00:00","dateAnswered":"2023-07-21T08:29:51+00:00","acceptedAnswers":[{"commentID":386336,"body":"