-
Improvements to Smartsheet Sights™, Reports, and User Management
We’ve just rolled out a new release that includes improvements to Smartsheet Sights, Reports, and User Management. Note that the referenced Help Center articles below will be updated with information on the new features tomorrow, Sunday (11/13) Let’s take a look at these new features! Sights: A new Title Widget allows you…
-
Can I run a report of all sheets I own?
I did some clean-up at the end of last year and apparently it made me the Owner of several sheets I did not create. I'm getting dozens of requests for access to random sheets. I'd like to run a report of all sheets Smartsheet says I own, so I can give ownership back for some of these sheets. I see that I can do a bulk…
-
Blocking Exporting
Hi, Is there currently an option or setting to block a viewer from being able to export data? I cannot seem to find it. Thanks!
-
Conditional formatting across multiple sheets
Is it possible to set conditional formatting to move an item from one sheet to another once it is completed?
-
Filtering Calendar View
Is there a way to filter the calendar view to show more information (from other columns) rather than just the primary column information?
-
Help with formula to avoid #DIVIDE BYZERO ERROR message
Hello, I have a large formula trying to achieve an AverageIf function - but I still sometimes get the #Divide By Zero error - any ideas of what i can do to the formula to avoid this? =SUMIFS([HEP Time (Minutes)]:[HEP Time (Minutes)], [HEP Name]:[HEP Name], "Galvin Davidson", [Current Month]:[Current Month], 1,…
-
Web Form Completion Remiders
Is there a way to set a reminder asking users to complete a web form?
-
Bar charts in tables using REPT function
I know SS is working on embedded charts for Sights but an easy workaround would be to have bar charts in a single cell using the Repeat function as in Excel. This is really a Text based formula cheat whereby a "|" is repeated by the value in question (i.e. =REPT("|",Ref) ). So, if you had a table and you wanted to rank the…
-
Exclude Weekends
I am trying to take a Due Date that has multiple tasks associated with it and create a Task Due Date based off the due date using a duration, but excluding weekends. For example, the Due Date is on a Monday, but the task needs to be completed 1 day before, which is a Sunday, so I need to date to populate to the Friday…
-
Update Requests status issue
Hi. I sent an update request, updates were made, but status haven`t changed, still shows as "pending". How can I solve this issue? Thanks in advance.