-
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…
-
Start and End date editing on my Ipad
I’m new to Smartsheet. I’m using an iPad Air to schedule construction projects for my company. In the Gantt view when I attempt to edit Start and End dates, the windows for them appear gray and it will not allow me to edit them. The other editing options windows are white and they allow editing. I am an admin in our…
-
Dashboard - Report Column Widths look ridiculous
I have a report that feeds into a dashboard with 8 columns: * At Risk (flag column) * Health * Task Name * Assigned to * Status * Progress Bar * Start Date * End Date Why does it stretch that last column (end date) so wide? It looks ridiculous. The At Risk flag columns is a very appropriate size for the content. So it the…
-
Card View Conversations
What am i missing, Card view is a superb feature of SS and starting to use lots, however when you add a task or subtask there is not an option to start a conversation, you have to go back to grid view for this. further more where there is a conversation in grid view the conversation box comes up when you open in card view…