Restrict a Checkbox from Getting checked (With out Using Dependencies)
Hello,
I'm trying to restrict a Done checkbox from getting checked before other boxes are checked first. My team created a project plan with multiple steps in the process. Each step has a done checkbox. I have a formula that fires when a specific box is checked but don't want folks to check that off sooner than they should. I'm not able to use dependencies because the dates that populate in the start and due date columns do not align with the dates in our project plan. Any suggestions?
Thank you,
Sean
Comments
-
Mike Wilday ✭✭✭✭✭✭
That is an interesting challenge. I am not aware of a way to restrict users from checking off a box based on the checking off another box first. I could see that being very useful in some instances! I wouldsubmit a product enhancement requestfor that idea. If someone else in the community knows a way to accomplish this I would love to hear it.
-
Sean Taber ✭✭✭✭
Ok, thank you for replying. I will do that.
-
TBrek ✭
Was this ever accomplished? A sheet of mine would benefit greatly from this feature.
Help Article Resources
Categories
Thank you, Carson! Did the trick.<\/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":107229,"type":"question","name":"Using the holiday parameter in workday function","excerpt":"=IF(Runs@row = \"Daily\", WORKDAY([Completed Date]@row, 1, {Holidays Range 1}), IF(Runs@row = \"weekly\", WORKDAY([Completed Date]@row - (WEEKDAY([Completed Date]@row) - 2), 5, {Holidays Range 1}), IF(Runs@row = \"Monthly\", WORKDAY(DATE(YEAR([Completed Date]@row), MONTH([Completed Date]@row) + 1, 1) - 1, 1, {Holidays Range…","snippet":"=IF(Runs@row = \"Daily\", WORKDAY([Completed Date]@row, 1, {Holidays Range 1}), IF(Runs@row = \"weekly\", WORKDAY([Completed Date]@row - (WEEKDAY([Completed Date]@row) - 2), 5,…","categoryID":322,"dateInserted":"2023-07-05T12:06:15+00:00","dateUpdated":null,"dateLastComment":"2023-07-05T19:31:23+00:00","insertUserID":120783,"insertUser":{"userID":120783,"name":"Lisa Vercellone","url":"https:\/\/community.smartsheet.com\/profile\/Lisa%20Vercellone","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-05T15:40:47+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-05T23:58:56+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":34,"score":null,"hot":3377146058,"url":"https:\/\/community.smartsheet.com\/discussion\/107229\/using-the-holiday-parameter-in-workday-function","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107229\/using-the-holiday-parameter-in-workday-function","format":"Rich","tagIDs":[254],"lastPost":{"discussionID":107229,"commentID":383804,"name":"Re: Using the holiday parameter in workday function","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/383804#Comment_383804","dateInserted":"2023-07-05T19:31:23+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-05T23:58:56+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-05T15:41:03+00:00","dateAnswered":"2023-07-05T15:21:35+00:00","acceptedAnswers":[{"commentID":383747,"body":"
It considers the holiday date similar to how it considers a weekend date. So if there is one holiday within the date range, it will add an extra calendar day similar to if there is a weekend within the range it will add two calendar days.<\/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"}]}],"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":[]}">