-
AVG(Collect) Formula help with date range
Is there a way I can give a date range in the formula below so that it averages between dates 8/21/19 - 10/29/19 =AVG(COLLECT({Nexus Dependencies Range 5}, {Nexus Dependencies Range 1}, "The Scrum Lords", {Nexus Dependencies Range 3}, DATE(2019, 10, 29)))
-
Parent and child relationship in CardView
Is there a way in CardView to show the Parent / Child relationship? For example, If in Grid view, row 6 is the Parent of rows 7, 8 9, and 10. In CardView can the card equating to row 6 be left justified and cards 7, 8, 9 and 10 be slightly indented to the right. Further in CardVirew being able to collapes rows 7,8,9,and 10…
-
Conditional Formatting if Checkbox is Checked
Hello everyone, I created a checkbox column with 3 cells set to toggle on and off conditional formatting rules. My idea is to paint certain cells if certain conditions are met AND one of the 3 cells is checked. I'm doing this mainly for aesthetic purposes as I don't want to have my sheet multicolored all of the time. Using…
-
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…
-
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.…
-
If Formula
Hi I'm trying to auto calculate the date. I was wondering if someone could assist. I'm not quite sure how to do it I believe it should be an if statement but I'm not sure how to write it. I have a column that is Date of Last Correspondence, Days till follow-up, Next Follow up Date is the column that I want to auto…
-
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.
-
Calculate Average for Duration Column
Hello, I have a column in a sheet that displays the duration for every project in our portfolio. I would like to calculate the average project length. When I use the AVG forumula, I get an error that says "# DIVIDE BY ZERO" Does anyone know how to get the average? Thanks!
-
Move Row Disables other Workflows
Hi all - I am looking into setting up a workflow that will move completed projects from one sheet to another once they are flagged as 'Complete'. The workflow seems to work ok, but as soon as I set it up all my other workflows seem to be disabled and I receive this message: 'This workflow is being prevented from running.…
-
Welcome screen - non-enterprise account
I am the system admin for a business account. I'd like to create a dashboard (with useful links to the most relevant sheets, forms and workspaces) for all users to see when they first log in to Smartsheet rather than seeing the last sheet that they were viewing when they last logged out. From what I understand, a welcome…
