-
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…
-
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…
-
How can i see who has changed which portion of the sheet?
Hi, I am having a situation wherein we are 2 Admins sharing the same Project sheet. I know that this is not the best way of handling the project/sheet. I would like to know, how do i see which portions of the plan is updated by my counterpart? I see a message that some changes are done and i need to refresh the sheet. I…
-
Calculating the task completion
I know this must be simple but unfortunately so am I I am managing a project and I have set it up with a fairly standard heirarchy of task (parent) and sub tasks (child). The sub tasks have a number of individual work items associated with them and I want to use the number of individual work items completed to…
-
Update Request Feature Request
When I send an update request it is usually schedule related. I often have a item that is several subtasks down. Please make it so that when I select on of those it displays the hierarchy of the tasks above. Currently I have to select each layer and then they show up as individul entry pages with no editable data which is…
-
Changing the date display format
Hi there, I'm aware that I can change how the date is displayed in my schedules by going into my personal settings and setting the relevant country (in my case, the UK), but I would like to adapt the display format further to show days of the week. Is this possible? Note: I'm using grid view. I'm aware I could switch to…
-
Showing weekend dates with conditional formatting
Hi there, Is there any way of showing weekend dates with conditional formatting? I would just like to add this to my schedules, so that when they're being updated, any dates that knock on to a weekend are highlighted for me. Note: some of my suppliers work at weekends and some don't, so I can't just change my settings to…
-
Admin can't edit sheet title
Good afternoon, While out of the office a sheet title had to be updated, and my fellow license holder, who is an admin for the sheet, was unable to do so under her profile. The rename option is greyed out. The only option for her to make changes in my absence is to login to my account. I trust her completely, but it does…
-
Shortcut link
Looking to create a summary smartsheet that has a list of sheet names in column A and shortcut links in column B. I know you can link cells within a sheet but i the desire is to link the entire sheet.