-
Notify an assignee that the predecessor required to start work has been completed.
I am looking for a solution that will allow an email to be sent to an assignee informing them that their part of a project can begin since a predecessor was completed. Any help would be greatly appreciated.
-
Automating Project Status
Hello, I would like Smartsheet to automatically assign a project status based on duration and number of days behind project. I have specifically been asked to assign a project status of red if the task is 20% behind schedule. Please let me know if you are aware of how to automate this in SS. Thanks in advance for your…
-
Update status field based on End date and %completion
Hello All, I would like to do some conditional updates in smartsheet based on below: 1) I want status field to reflect Green if End data of task is greater than today's date 2) I want status field to reflect Red if End data of task is less than today's date and % completion is less than 100%. 3) I want status field to…
-
Filtering Older Data
I was wondering how to use smartsheets to filter out older data in a log. For example in a purchasing log, what I did at first was creating a checkbox column with cells such that a order that arrived for longer than 2 weeks will be filtered out: =IF(AND([Last Modified]1 < TODAY(-14), Status1 = "Arrived"), 1) That function…
-
Rule Creation Help Needed!
Hello - I am managing a Smartsheet action item log. I need any row that is deemed 'complete' to be moved down into a completed section further down the sheet. Is there a way to set this up to be automatic vs. manual?
-
Specific Dates in Columns
Hello, I have a column that users must input a date that their project will attend a specific meeting. This meeting only happens on set days every month, so I am wondering if there is a way to only allow a user to choose/put a specified date in the cell for that meeting. For example, if that meeting happens on August 9th…
-
sum column and calculate total to hrs:min
I have a "duration" (used to track time involved) task field that I need to be sum and show on a report as hours:minutes. The column is a drop down field with numbers only in 15 min increments. example: 15 30 45 60 75 90 etc... Appreciate any replies.
-
Smartsheets for medical practices
Does anyone know if smartsheets solutions can be used to manage medical projects? This would include documenting information that would flow via api into an existing enterprise system.
-
Conditional Formatting to work on rows like they do on columns
Hi Is it possible to set conditional formatting on rows like it is for columns, or is there a workaround? Thanks Cheers Richard
-
Count Past Due Tasks
Hi there - I'm new to formatting / formulas in smartsheet (and excel for that matter) and haven't had much luck creating a formula that counts tasks that are past due. While able to use conditional formatting to visually identify these items I'm trying to roll this up into a project overview; the overview/dashboard -…
