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.

Filtered View in a Reminder

Carol Anne Wall ✭

01/24/17 edited 12/09/19 inArchived 2017 Posts

I want to use a filtered view in a reminder sent to all users of the sheet. Two other alternatives if that cannot be done would be to create a reminder in a report, or to stop the SmartSheet from displaying in the standard reminder.

The goal is to send a reminder to team members that shows just the current phase of a project -- or nothing at all, just a link to the filtered sheet view.

TIA!

Tags:

0 ·

Comments

Shaine Greenwood Employee

01/25/17

Hi Carol—

We don't have a way to create this type of conditional reminder logic on a sheet, and there isn't a way to set a reminder from a report. I'll add your vote for these features to our enhancement request list for further consideration.

0 · Share on Facebook Share on Twitter

This discussion has been closed.

Categories

This has to do with how a milestone is represented (ie. a 0 day duration). If you hard type milestone without a predecessor or successor, it will show up as the beginning of that day instead of the end of the day. If you have a milestone that is following a standard finish to start logic, it will show up at the end of the previous activity. <\/p>

So, Task B4 in the backwards version is actually saying that the completion happened in the 00:00 hr of that day. if you put any activity in that has a duration and uses the start to finish relationship, that activity will naturally finish at the end of the previous day. So, to get your example above to work, the finishing task would need to be 1 day long so it takes up the full work day. I found it easier to visualize if you zoom all the way in on the gantt chart so you can see the diamond symbol of the milestone at the beginning and end of the days when used in different set ups.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"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":108291,"type":"question","name":"Conditional formatting in Gantt not working with dependencies","excerpt":"For some reason it seems like my conditional formatting rules aren't being applied to certain rows in the Gantt chart side of this sheet. The problem is resolved if I disable dependencies, but I need those and don't understand why this should matter since I don't have any rules related to status or % complete in the…","snippet":"For some reason it seems like my conditional formatting rules aren't being applied to certain rows in the Gantt chart side of this sheet. The problem is resolved if I disable…","categoryID":321,"dateInserted":"2023-07-29T22:50:55+00:00","dateUpdated":null,"dateLastComment":"2023-07-30T15:38:08+00:00","insertUserID":164323,"insertUser":{"userID":164323,"name":"smbailey","title":"Senior Business Systems Analyst","url":"https:\/\/community.smartsheet.com\/profile\/smbailey","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-30T15:36:49+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":164323,"lastUser":{"userID":164323,"name":"smbailey","title":"Senior Business Systems Analyst","url":"https:\/\/community.smartsheet.com\/profile\/smbailey","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-30T15:36:49+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":30,"score":null,"hot":3381404343,"url":"https:\/\/community.smartsheet.com\/discussion\/108291\/conditional-formatting-in-gantt-not-working-with-dependencies","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/108291\/conditional-formatting-in-gantt-not-working-with-dependencies","format":"Rich","tagIDs":[219,319,437,439],"lastPost":{"discussionID":108291,"commentID":387971,"name":"Re: Conditional formatting in Gantt not working with dependencies","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/387971#Comment_387971","dateInserted":"2023-07-30T15:38:08+00:00","insertUserID":164323,"insertUser":{"userID":164323,"name":"smbailey","title":"Senior Business Systems Analyst","url":"https:\/\/community.smartsheet.com\/profile\/smbailey","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-30T15:36:49+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":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/4N6Y1NCLVR43\/2023-07-29-15-46-58-281-29-moving-plan-smartsheet-com.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"2023-07-29 15_46_58-(1) Moving plan - Smartsheet.com.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-07-30T15:39:24+00:00","dateAnswered":"2023-07-30T09:21:36+00:00","acceptedAnswers":[{"commentID":387967,"body":"

Hi @smbailey<\/a> <\/p>

I hope you're well and safe!<\/p>

I can't see any rows in your screenshot that should be colored differently. Parent rows can't be changed.<\/p>

Can you share more screenshots with the conditional formatting options used on a few child rows?<\/strong> (Delete\/replace any confidential\/sensitive information before sharing) That would make it easier to help. <\/p>

I hope that helps!<\/p>

Be safe, and have a fantastic weekend!<\/p>

Best,<\/p>

Andrée Starå<\/strong><\/a> | Workflow Consultant \/ CEO @ WORK BOLD<\/strong><\/a><\/p>

It is not possible to transfer cross sheet references from one sheet to another already existing sheet. Feel free to submit an enhancement request using the \"Product Ideas\" tab at the top of this sheet.<\/p>

<\/p>

If you have created these cross sheet references and then \"save as new\" the project sheet, the cross sheet references will copy over as well. It is just transferring them to an already existing sheet that isn't possible.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"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":334,"urlcode":"automations","name":"Automations"},{"tagID":446,"urlcode":"update-requests","name":"Update Requests"},{"tagID":472,"urlcode":"cell-linking","name":"Cell linking"}]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&includeChildCategories=1&type%5B0%5D=Question&excludeHiddenCategories=1&siteSectionID=0&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 Posts","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">