-
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…
-
Mathemathical Operations on Dates/Date Columns
Hi, is it possible to perform mathemathical operations on dates/date columns in Smartsheet. Specifically, can I "deduct" one date from another or somehow calculate the difference (in days) between the two? Thank you.
-
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…
-
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…
-
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…
-
Separating weekdays from weekends
Hi everyone, this is probably something very simple, but I still struggle, hope you can help. I have a large timesheet with one raw per day, every day of the year. The contractors will get paid higher rates on weekends, compared to work days. Initially I thought of putting an extra checkbox "weekend" column next to the…
-
SUM of linked values
Hello, How do i create a SUM of linked values from other sheets? If i break the links and add a numeric value the SUM-formula works. Best regards
-
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…
