-
Summary Row Card View
Hello, I cannot find any resources showing how to create a summary row card in card view. My lanes are based on stages of a project which is selected through a drop down on each row. I would like to total the NPV of each project that is in that stage (NPV is one of the columns in my sheet). How do I do this? Thanks!
-
Predecessor links disappearing when printing in PDF
Hello members, Need a quick help. I have a project and in the gnatt view the predecessor links are visible: See screen shot Gnatt mode. When I want to print this gnatt chart, the links disappear in the PDF mode. See screen shot PDF mode. Can someone tell me what am I doing wrong as I would like to see the predecessor links…
-
Unhide particular columns rather than 'unhide all columns'
It would be useful to be able to unhide only certain columns, rather than 'all', when you have spent some time creating a partiuclar view (say for instance you are projecting in a meeting, so have a smaller screen size), but realise you need to show just 1 column, instead have to rehide all again.
-
Calculating a date from another date in same row
how do I have the start prepping date calculate off the meeting date automatically in the same row. ie I have a meeting on 1/22/18 and I need to start planning 10 weeks prior and would like it to be automated. The problem is this is a major calendar for over 30 meetings, and all have different lag times for planning. I…
-
2 week task for 2 hours each day
Is it possible to have a task with a duration of say 2 weeks, but only allocate a fraction of the day’s hours to the assigned resource? For example, John Smith is assigned Qlik development that will last for 2 weeks, but will only be developing for 2 hours/day. I know it’s possible to change the default length of a day…
-
Totals By Date
Hello, Has anyone successfully used dates to pull totals? I'm trying to do the following: Columns: Start Date | End Date | Status 1/2/18 1/10/18 Completed 1/5/18 1/7/18 Completed 1/5/18 Open 2/8/18 2/15/18 Completed 2/16/18 2/20/18 Cancelled Output: Total 'Completed' for January 2018 = I'm wanting to use the dates and…
-
Filtered Views for External Collaborators
Hello, i am not sure what the best way is to accomplish this. I have a smartsheet that i would like to collaborate with outside vendors. I would like to avoid chopping up the data and giving every vendor their own sheet. I will be adding new data weekly. Update request won't work because they could be getting 20+ lines at…
-
Resources allocation / staffing at hourly granularity
Hi. we have the need for a tool that will allow us manage short & simple projects (hours/days) for our team. Something like Float.com. As we are using Smartsheet already, i'd prefer to find a solution that utilize SS, instead of bringing to the company another solution. But - I didn't find a way to work on an hourly basis…
-
Need help with a recurring report formula
Hi. I am new to Smartsheet and it has been a while since I have done alot with formulas in Excel. I am setting up a report tracker for our organization that will have recurring reports due on a weekly, monthly, and quarterly frequency. I need some help with a formula to automatically adjust the next due date so that…
-
Calendar View
My conditioning format does not show when I view my smart sheet in the "calendar view". Any suggestions?
