-
Creating a report, Not able to select column that exsists on sheet.
Hello, I use the same sheet frequently and change the title/calendar to fit the need of the project. I also use the same report, and generally just change the sheet the search is restricted to in order to generate calendars for sub contractors for the specific project. However, I'm having a strange error. I'm trying to…
-
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…