-
Ghant Chart with quarter headings
I really like the quarterly level ghant chart. However, when the earliest task begins near the end of the quarter, I have two months of blank ghant. I thought that I could force it to show only the part of the quarter that has a task by specifying a date range. But, I still get the blank part of the quarter. Is there any…
-
Templates for Legal Project Management?
Does smartsheet have any plans to add templates for Legal Project Management (LPM)? LPM is becoming a neccesity in the Legal environment and is different from Technical Project Management. Curious if you are looking to add any templates for LPM? Thank you
-
2016 Calendar By Day
Hi, I am trying to reconstruct a legal time line for 2016. I see have my option for 2017 and 2018 does anyone know how to do this. Thanks,
-
Formula to count a number of dates, based on a date range.
Im trying to create a formula for a report based on howmany entrys have been created within specific date ranges. For example: how many entrys have been created 04/15/15 - 04/20/15 in column "date of entry" (auto number column). Please help! Best regards,
-
Autofill a value
Hi. I'm new at building formulas in Smartsheet. I have a numeric column that I want to autofill a 1 if no value is entered. Can someone help me with this?
-
Selecting specific columns for alerts & reminders
Is there a way to select specific columns for displaying on alerts? Currently all columns display on the alert including a column that I have for my own use. Thanks, jerry
-
Locking Cells/Columns in a Report
Hi Smartsheet - I recently created a series of report in smartsheets that pull specific pieces of information for departments so that managers can see their respective things and provide updates. However, unlike a regular sheet, where you can lock certain columns so as to prevent users from being able to edited field, we…
-
Master Task List By Resource
We have multiple projects ongoing simultaneously. In each project tasks are assigned to various team members by the managing partner. Is there a way to have a task automatically roll into a master task list for the manager by resource (sort of a pivot table) or a consolidated task list for each resource team member to…
-
Specifying task durations in months
This may sound like a foolish questions..... I specify my task durations in days. Can I specify some of them in months? The reason I ask is that I noticed that when I enter a duration as 6 it displays "6d" for 6 days. We have a number of tasks that have contractual commitment in 3 months. Therefore, the need to be able to…
-
Including only the most recent comment.
Hi there, Within the "Print Setup" for .pdf reports, under "Options", "Include comments" checkbox....when selecting this checkbox it prints out the full set of comments which is fantastic but can make the report quite lengthy, especially over time. However is there a way, or is it possible in future upgrades to select an…
