Restrict a Checkbox from Getting checked (With out Using Dependencies)

Sean Taber
Sean Taber ✭✭✭✭
edited 12/09/19 inFormulas and Functions

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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the公式手册模板!
=COUNTIFS(DISTINCT([1st]375:[31st]404), <>0, DISTINCT([1st]375:[31st]404), <>786)<\/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":107244,"type":"question","name":"COUNTIFS, ISBLANK, NOT(ISBLANK)","excerpt":"Hi...I want Smartsheet to count a row if it meets three conditions: the \"Watchlist\" box is checked, there IS data in the \"Beacon Submission Done\" column and there IS NOT data in the \"In PRD column.\" Current formula is throwing Invalid Argument Set error: =COUNTIFS({Watchlist 20230615}, 1, NOT(ISBLANK({B Sub Date})),…","snippet":"Hi...I want Smartsheet to count a row if it meets three conditions: the \"Watchlist\" box is checked, there IS data in the \"Beacon Submission Done\" column and there IS NOT data in…","categoryID":322,"dateInserted":"2023-07-05T17:59:02+00:00","dateUpdated":null,"dateLastComment":"2023-07-05T19:18:17+00:00","insertUserID":163159,"insertUser":{"userID":163159,"name":"Deb W","url":"https:\/\/community.smartsheet.com\/profile\/Deb%20W","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-05T19:58:09+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":163159,"lastUser":{"userID":163159,"name":"Deb W","url":"https:\/\/community.smartsheet.com\/profile\/Deb%20W","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-05T19:58:09+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":31,"score":null,"hot":3377165839,"url":"https:\/\/community.smartsheet.com\/discussion\/107244\/countifs-isblank-not-isblank","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107244\/countifs-isblank-not-isblank","format":"Rich","lastPost":{"discussionID":107244,"commentID":383801,"name":"Re: COUNTIFS, ISBLANK, NOT(ISBLANK)","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/383801#Comment_383801","dateInserted":"2023-07-05T19:18:17+00:00","insertUserID":163159,"insertUser":{"userID":163159,"name":"Deb W","url":"https:\/\/community.smartsheet.com\/profile\/Deb%20W","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-05T19:58:09+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\/YRHZOTOC3VXV\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-07-05T19:18:22+00:00","dateAnswered":"2023-07-05T19:18:17+00:00","acceptedAnswers":[{"commentID":383801,"body":"

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":[]}">

Trending in Formulas and Functions