-
Security loophole
We have a sheet containing sensitive data in several columns. We limit the visibility of this data by hiding the columns, so only Admin users on the sheet can unhide/view the data. However, any Smartsheet licensed user, including those with only Viewer privileges, can circumvent the sheet security by simply saving the…
-
Export of reports do not properly show diamond
Hi there, When I make an export (gantt to image) of a report including a few milestones, they don't get exported as diamonds, but as 1 day events. Is this a bug? Because when I look at the Gantt view in Smartsheet itself, then the diamonds are displayed correctly. Thanks!
-
Track date change for column
Hi--I know I can track when any change is made to a specific row. And I know I can right click and see change history for any given cell. But is there a way to bring that date into the sheet itself so that it can be used in formulas (for example to compare the date that a certain event occurred in relation to the date a…
-
How to have child rows displayed using parent data
Hi all, I have a complex sheet which is efectively a "to do" list. Thanks to the community I have it working pretty well as I want and am very happy with it. To polish the sheet, I would like to achieve the following: I have my todo's organised by project then category. For example, I have a column called "project" which…
-
Inconsistency with using Fix Version as JIRA Filter in Workflow
I'm not understanding the logic used by the JIRA Filters section of the Workflow builder. I'm trying to filter by unreleased versions. In the best case scenario (which I don't think is available), I'd be able to specify Fix Versions equals earliestUnreleasedVersion() or, better yet, more operators could be added and I…
-
Combine tasks from different sheets into a single calendar view
How do I combine tasks from different sheets into a single calendar view? I have my sheets broken out by niche within my firm. I'm the marketing director of a CPA firm with oversight of marketing many niches; I'd like to see all daily responsibilities in a single calendar view. Is that possible? Thanks. Joe
-
Help with Date function please:
20th of the month..... 01/01/17 returns 20/01/17 .....need 20/02/17 31/01/17 returns 20/03/17.....need 20/02/17 #Invalid Data Type if Invoiced date empty (Where dose IFERROR go) DATE(YEAR([Invoiced Date]2), MONTH([Invoiced Date]2 + 30), 20)
-
Hyperlinks Are Lost When a Sheet is Exported
When I export any of my smartsheets where there is a hyperlink connected to text within a cell, the link is lost. It doesn't matter if it's an excel sheet, google sheet, or PDF, the links are lost and have to be reconnected from scratch. Is there a work around for this?
-
Dis-aggregate SS start and end dates in exported Excel
Hello, I am trying to see if any of the Excel wizards here can help me with a script or other macro that will disaggregate my SS exported project sheet data that contains start and end date columns (along with the usual duration column) information into individual rows for each day/date that is bounded by the SS start and…
-
Resource Scheduling
Has the ability to adjust a resources work schedule been added?