-
How to calculate number of days overdue on a task
Hi, I am new to the community. I would like to create a status field that changes color based on number of days overdue. Is there a way to calculate the number of days overdue in smartsheet? Thanks in advance! Susanna
-
Resource Allocation
I would like to create a Team in Smartsheet that is identified as a Resource. Is it possible to create a Resource without assigning an email to the resource?
-
Formula for a carriage return within a cell
Hello i have this formula for milestones, however I would like to format it so that the "Milestone Count, Milestone Reached, Milestones to Go are all lined up to the left of the cell. I cannot change the size of the cell as there are multiple tasks in that same column. ="Milestone Count. . . . . . . " + COUNT([Notify…
-
Automatically update related tasks when one date changes
Hi! My team is using Smartsheet for project management, and I want to know how to update due dates for tasks that are related. For example, if my original due date is 1/1/17, and there are several other tasks that are related to the starting date (edit, layout, print, etc.), if I change the date of one of those tasks, how…
-
Automating swim lane changes in Card View
Does anyone know of a way to automate moving a card/task that has been set to 100% complete in the % completion data field into the "Complete" column / swim lane in the Card View (or for that matter, automating any swim lane change in the Card View based on any task data parameter)? Currently it's a manual process of…
-
Formula for capturing the date when the status column change
Hi, I have a completion date column. I want to know if there is a formula I can capture in the date column to indicate that specific date when the Status was changed to complete? Please help. Yovanka
-
Project Management classes?
I'm wondering if Smartsheet has any recommendations for online classes to receive certification in Project Management. Blessings, Loann
-
Emailing report if cell is changed.
Is there a way to have a report email only if a cell is set in a certain way? I have a report that I want to email but only if there the box marked review is checked. Is there a way to do this?
-
Alert with custom time
On the Alert feature, will there be a custom feature when the reminder or e-mail be sent out? Some staff that I work with start at 5 AM and some leave at 5 PM. It would be great if the reminders will be sent when they walk in and/or an hour before they walk out of the office. Thanks
-
Project sheet start/finish dates
Hi all, Pretty much all my projects work over weekends. I am trying to set deadlines for start or finishes that land on either a Saturday or a Sunday, however, the project template keeps defaulting the dates back to the Friday. Any suggestions? Cheers