-
Apply formulas to data aggregated in a report
So we've just started using smartsheet to track hours used for different projects. Each person gets one individual sheet to fill in. Once a week a report extracting the hours from the last 7 days is extracted and sent to the people keeping track of the mother organization. However, as a manager I'd like to keep track of…
-
Advanced User Training
Does anyone know if Smartsheet has ever had (or is planning) advanced user training available, similar to the Smartsheet Academy you can attend in person? or a User's Conference? It would be much easier to sit in a room with other advanced users and share ideas in person vs. on the web.
-
Links to external sites in a Report
I have a sheet with a column that includes a URL link to an external website. I have reports that include this column and I noticed that in the report the LINK is no longer a clickable link. I can double click on the cell and "see" and copy the URL but not click on it. Has anyone figured out a way to make the link an…
-
Large doc with rows of data - dates
I have a sheet that we use to co-ordinate service work. It is getting pretty big. Is there anyway to have Smartsheet automatically go to todays date on the sheet, as opposed to starting at row 1?
-
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.
-
How can I write a formula to summarize in parent row summaries in child rows?
Column is entitled Status and is a drop down list with the following selections: Not Started In Progress Delayed Cancelled Complete I have a formula in each child row to summarize grandparent rows: ="Not Started (" + COUNTIF(CHILDREN(), "Not Started") + "), In Progress (" + COUNTIF(CHILDREN(), "In Progress") + "), Delayed…
-
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…
-
Finding cells that aren't linked
Hi everyone. I have created a mastersheet (A dashboard), where i link cells from 10-15 other sheets (Project sheets). What i want to do is to create a report, that will "catch" any rows that are added withing the project sheets. Basically what i want to do is to keep my Dashboard up-to-date when changes happen in the…
-
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…
-
Duration as a report filter
I'm trying to set up a report of my to-dos that have a duration of 5m or less but am having trouble setting up a duration filter based on anything other than whole days. I know I could probably create a custom column in every sheet with a checkbox to say the task takes 5 min. or less or a formula converting the duration…