-
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…
-
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…
-
Misc feature requests
The following features/enhancements would be useful: * -Card view also for reports * - Conditional formatting applied in reports * - BOX task integration (tasks assigned in BOX could be displayed as a separate report) * - Reports from reports, not only from sheets. This would enable more advanced filtering * - A report…
-
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.
-
Formula return Column date plus 7 days IF column value is less than 3
Hi, I am new to smartsheet (spreadsheets in general) and I am trying to create a task list sets a due 7 days after a task was created if the priority of that task is less than 3. The formula i have so far is: =IF([Priority]1 < 3), [Created]1 + 7 I get an error saying Missing or invalid parameters. I'm not sure what im…
-
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…
-
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?
-
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
-
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…
-
Two Smartsheets- linked- add row in one- can it auto add linked in 2nd?
Hi, I"m working with two smartsheets for test planning.... The primary sheet goes over the what is being tested, which teams, the planned volume & dates. The second sheet is for results reporting and links back to some key fields in the primary sheet. Problem I have- if i add data to the primary (ie new test event)- is…