-
Multiple Duration columns (or a way to calculate number of day between two date columns)
I'm trying to setup a sheet for tracking actual work dates vs target dates Construction Document set timing. In each deliverable/row I'd like to list the following dates: • Target Date * • Act Start * • Act Finish * • Approval Date I have my the project settings turned on so that "Act Start" and "Act Finish" create teh…
-
Two Smartsheets- linked- add row in one- can it auto add linked in 2nd?
Hi, I"m working with two smartsheets for test planning.... The primary sheet goes over the what is being tested, which teams, the planned volume & dates. The second sheet is for results reporting and links back to some key fields in the primary sheet. Problem I have- if i add data to the primary (ie new test event)- is…
-
Real time & ressource management
Smartsheet is a great product with great features, but it lack in crucial features for any real event and logistic planning. Add time/duration management for task When selecting a start and end date for a task, we should be able to select a time for it as well. We cannot be limited to fixed hours work day or using "gaps"…
-
Hierarchy in Reports
Is there any intention of offering a hierarchy in the Report view? This would be especially useful where the report includes parents of the items found for the report. Thanks in advance, Neil
-
Kanban Project management
Hi Would it be possible to have a Kanban view of the projects I have setup? It could be organized easily by have a collumn with the different Kanban collumns as menu items in a dropdown menu. Then, when entering Kanban view all tasks displays as items in the Kanban collumn they belong to. This would alow a flexible…
-
Web form access to registered users only
Hi, I want to provide the acess of web form (via link provided) to only registered users and want to fetch the user in same form who has accessed it. Eg. If userA fills up the form and sumbit, my web form sheet should show Form filled by "userA" Please suggest.
-
Tracking actual dates without losing predecessors ?
i use baseline start/finish columns and scheduled start/finish columns. The start column uses predecessors but I also update the start/finish columns for actual start/finish. The downside to updating them is that i lose my predecessors (they are deleted when I manually change start/finish). Is there a SmartSheet best…
-
HELP!!! I am working on a nested IF formula that just doesn't work, any help is appreciated.
I am trying to calculate the total revenue per month as well as the Margin % per month from our Sales Pipeline. Some of the projects run into the following month so we need to see what the revenue and margin are for each part of that time frame. I was able to get the formula to work for the margin % but only for one cell…
-
How to get team involved
What are some ways that you are implementing Smartsheet into your company, team, etc.? I am the creator of the Smartsheet system in my company. I have found that because I have spent so much time in the sheet I have a gap between me and my team that is difficult to close. It all come down to how we get our people into the…
-
Indent Copied Tasks isn't working
Hi all! I'm copying a large number of tasks and have pasted them where I want them. Only problem is, they got outdented as far as they can go, and the indent button is greyed out when I select them for intention. Any clue why this is happening?