-
The Time it Took to Perform a Particular Action
Hi, I realize the questions is quite vague, but is there any way to show/calculate (this need not necessarily be done via a Report as the word is used in Smartsheet terminology) the time it took for somebody to complete a certain action. I,e. let's say there's a task that somebody is assigned to and they begin this task by…
-
Highlighting changes on a sheet
If I highlite changes done to a sheet for me within the hour or so, will this rule show up for others or does everyone need to setup this highlighting feature themselves?
-
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…
-
Current date against a ticked checkbox.
Hi, I'm trying to come up with a formula that will populate a given cell with the current date if and when a certain checkbox has been ticked. Please note, this date must be fixed, i. e. it must NOT change as the days go by. Is this possible at all? I know this is completely wrong, but just to illustrate better what I mean…
-
I want to set the name of a field to be the column name it is in. Is that possiblle?
I want to set the name of a field to be the column name it is in. Is that possiblle?
-
Move to Completed
Our team is using the Team Tasks by Priority template. Is there a way to automatically move completed tasks under the completed hierarchy?
-
Training Record
* Hi * I am wanting to create a sheet to keep track of our employee traing records. We have approximately 20 employees all with a number of training qualifications which they need to re-sit at diiferent intervals. I need to be able to list the employees with rows or columns for their qualifications where we can enter the…
-
Is there any way to use Check Box List?
-
Hi struggling a bit on the correct formula for overdue tasks
Hi, I need a function to look at If a column completed date is blank and the end date column date i s more than today to the return status "overdue" so I can report on overdue tasks ?
