-
Parent Row Formula Based on Children's Status
How do I use a formula in my parent row to update based on the children's status? I want the parent row to to "Active" if any of the children are "Active", "Complete" if all of the children are "Complete, otherwise, "Inactive.
-
the start of a squeeze? what is the community view?
The email below is the start of a squeeze, the direction of which I’m uncomfortable with and which is ultimately designed to force the switch of collaborators into license holders. Removing ‘View Cell History’ from collaborators is a particularly unwelcome surprise. From: Smartsheet Team <productinfo@smartsheet.com> Sent:…
-
Formula Help!!!
I can't get this formula to work. Any glaring mistakes? =IF([Date Received at Settlement Desk]1) = "", "", IF([Date of Payment]1 = "", NETWORKDAY([Date Received at Settlement Desk]1, TODAY()), NETWORKDAY([Date Received at Settlement Desk]1, [Date of Payment]1))) Thanks!
-
Indefinite Lag Times?
Hi, I am trying to set up some predecessor relationships between tasks that don't have a definite lag time associated with it. I just need the relationship to require Task A to wrap up before Task B. Task B doesn't need to start immediately after Task A is done, but it CAN NOT start before. For example, I am doing a…
-
Status Bubble Not Changing Based on % Complete Formula
Hello, I am currently trying to find a way for the Status bubbles to automatically color based on the % Complete column. Reviewing other posts I found and have tried the formula below, but it only works correctly for Red and Grey. When the percentage is above 51 or at 100 the color remains red. =IF([% Complete]2 = 0,…
-
Splitting user stories to new iteration/sprint
For sprint tracking and planning, I'm wondering what others are doing when they need to split a story that isn't finished in the last iteration/sprint. For example, I want to be able to track that the story was worked on previously in sprint 3, was put on hold for 3 months and now is being worked on again in sprint 6.…
-
Removing someone from alerts
Is there a way to remove a past employee from all reminders? I am trying to avoid having to go through each item/reminder. Thank you!
-
Export Dashboards
Hi All, I really need to export my reports and dashboards and the PDF option is too limited. After exporting to PDF and then using a program to convert to PowerPoint or Word, the quality is not the same. We as a company would strongly recommend the option to export reports and dashboards (Word, PowerPoint, etc.) directly…
-
Linking Reports in different sheets
hi guys background: I work for an investment management company. Internally we have about 6 different reports that are interlinked in this manner Report 1: the starting point is an events or presentation calender Report 2: the actual presentation report, where feedback is gathered from presentations that come from the…
-
Watchlist Alert
Hi there, So I am trying to the set up an Automation workflow for the following scenario: If the task status is still in progress or not started, then the system will send a select user a notification 30 days after the set END DATE. This is what I set up in the workflow, but I don't believe this is correct.
