-
Priority rows
How do I insert a priority row and lock it. thanks Kurt
-
Formula help...can this be done?
Column A is a date column. Column B tells us if we have scheduled Column A so it will sort into the right report. The formula in Column B needs to state that if Column A is a date, then the value is YES; If Column A says "Not Scheduled" it is No. Otherwise, Column B will remain blank. Can that be done? Blessings, Loann
-
RYG balls based on task completed
I have a sheet where I want to update the next columm based on the RYG color of the first. For example: If Column 1 = Green then I want Column 2 = Blue I think I am close on the formula but it just isn't playing nice. Thanks!
-
RYG balls based on dates of activities completed
I have been following some threads discussing how to use RYG balls in conditional formulae based on a date column (i.e. green if the date is in the future, yellow if it is today, red if in the past, etc.), and those are very helpful! I would like to do the following, however, and I cannot find a thread that addresses this…
-
Auto-fill formulas and corrupt references
Hello, I'm currently in the process of setting up a rather formula-heavy project sheet, linking project names, project numbers and multiple assignees to all the different tasks within the project. In order to circumvent the limitation of one assignee per task on my sheets, I've created additional (non-Contact list) columns…
-
Calculating a Due Date
Frequently in legal transactions a transaction closing date may depend on the outcome of a couple or more previouls tasks. It will be the later of two or more previous tasks. Each task's completion date plus a different number of days depending on the task. The answer is the latest plus another specified number of days.…
-
Multiple Duration columns (or a way to calculate number of day between two date columns)
I'm trying to setup a sheet for tracking actual work dates vs target dates Construction Document set timing. In each deliverable/row I'd like to list the following dates: • Target Date * • Act Start * • Act Finish * • Approval Date I have my the project settings turned on so that "Act Start" and "Act Finish" create teh…
-
Two Smartsheets- linked- add row in one- can it auto add linked in 2nd?
Hi, I"m working with two smartsheets for test planning.... The primary sheet goes over the what is being tested, which teams, the planned volume & dates. The second sheet is for results reporting and links back to some key fields in the primary sheet. Problem I have- if i add data to the primary (ie new test event)- is…
-
Real time & ressource management
Smartsheet is a great product with great features, but it lack in crucial features for any real event and logistic planning. Add time/duration management for task When selecting a start and end date for a task, we should be able to select a time for it as well. We cannot be limited to fixed hours work day or using "gaps"…
-
Hierarchy in Reports
Is there any intention of offering a hierarchy in the Report view? This would be especially useful where the report includes parents of the items found for the report. Thanks in advance, Neil
