Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, pleaseVisit the Current Forums.
Mandatory Cells
I've done a formula to add "date required" when the box is checked and " " (blank) when date is not checked.
Issue is when the user puts the date in the field, it removes the formula, so if they unchecked the check box, or remove the date, the date remains blank.
Although I have formatted the cell to stay Red if blank, I'm interested to know if there is a way of making the "date required" return when the cell is blank again automatically?
This is simply say if someone checked the box by mistake or removed the date by mistake, they would be reminded that this was not complete..
Comments
-
In a similar issue I could only solve it with a supplementary column (which I locked) in which I formuled the automated messages.
-
That is actually a great work around lol
Categories
If the two percent columns are formatted as percent columns (see screenshot), then the % Not Complete column would have this formula: <\/p>
=1 - [%Complete]<\/em>@row<\/p> Hope this helps!<\/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"}]},{"discussionID":107019,"type":"question","name":"Data Mesh Run Immediately","excerpt":"I saw a post from 2019 stating that the Run Immediately wasn't working and someone responded that there were issues. Was this resolved? I see the original question is from 2019 but when I tried using \"Immediately\" today it doesn't seem to run either. I was hoping to use \"Immediately\" as a run time since the person who owns…","snippet":"I saw a post from 2019 stating that the Run Immediately wasn't working and someone responded that there were issues. Was this resolved? I see the original question is from 2019…","categoryID":343,"dateInserted":"2023-06-28T14:24:46+00:00","dateUpdated":"2023-06-28T14:53:46+00:00","dateLastComment":"2023-06-28T17:13:57+00:00","insertUserID":120231,"insertUser":{"userID":120231,"name":"Pamela Wagner","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Pamela%20Wagner","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-28T17:01:11+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"updateUserID":91566,"lastUserID":124290,"lastUser":{"userID":124290,"name":"Adriane Price","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Adriane%20Price","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!BmjXAS9m9aY!oUjUqI9WkTY!3brbJb9YCMB","dateLastActive":"2023-06-28T17:17:33+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":18,"score":null,"hot":3375936523,"url":"https:\/\/community.smartsheet.com\/discussion\/107019\/data-mesh-run-immediately","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107019\/data-mesh-run-immediately","format":"Rich","lastPost":{"discussionID":107019,"commentID":382913,"name":"Re: Data Mesh Run Immediately","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/382913#Comment_382913","dateInserted":"2023-06-28T17:13:57+00:00","insertUserID":124290,"insertUser":{"userID":124290,"name":"Adriane Price","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Adriane%20Price","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!BmjXAS9m9aY!oUjUqI9WkTY!3brbJb9YCMB","dateLastActive":"2023-06-28T17:17:33+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":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-28T17:04:09+00:00","dateAnswered":"2023-06-28T16:59:56+00:00","acceptedAnswers":[{"commentID":382898,"body":" @Pamela Wagner<\/a> - Hello<\/p> The column mapping you setup in the DataMesh configuration is used to determine what information needs to link or copy and where it needs to go. The Execution Frequency<\/strong> is what tells the system when to run the DataMesh workflow.<\/p> Execution Frequency: Scheduled execution frequency to update DataMesh values.<\/p> The Update Immediately<\/em> execution frequency isn't supported when using a report as your source. If using a report this could be why you are not seeing updates immediately.<\/p> As far as what triggers a workflow to run when \"Update Immediately\" is selected, DataMesh looks for matching cell values and these could come from manual entries, formulas, or cell links. When there is a successful mesh you can see the CONFIG LOGS by clicking the paper icon.<\/p> After clicking the paper icon a CONFIG LOGS window will pop up showing a history of all the successful and errors.<\/p> If it is unsuccessful the paper icon will be red or in the CONFIG LOGS it will show the error.<\/p>![\"Menu.PNG\"](\"https:\/\/us.v-cdn.net\/6031209\/uploads\/CAZC0IAD3A4B\/menu-png.png\")
<\/img><\/a>\n <\/div>\n<\/div>\n![\"Screenshot](\"https:\/\/us.v-cdn.net\/6031209\/uploads\/KGDIFS874DA3\/screenshot-2023-06-28-105433.png\")
<\/img><\/a>\n <\/div>\n<\/div>\n![\"image.png\"](\"https:\/\/us.v-cdn.net\/6031209\/uploads\/H8M3P40BH8RP\/image.png\")
<\/img><\/a>\n <\/div>\n<\/div>\n
<\/p>
