-
Alerts for only incomplete tasks
I routinely send auto alerts 3 days before a task is due to serve as a reminder. I recently began sending another alert on the date that a task is due. However, I don't want to send the alert if the task is 100% complete. I guess that I was assuming that the alert wouldn't be sent if the task is complete. Is here a way to…
-
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…