-
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.
-
Webform - Enter a default formula instead of value for Symbol data type
I'm hoping someone can advise how to get around this issue. I have a new sheet I'm creating which acts as a checklist in a fixed process. i have several columns which cover off stages in the process, and there is a master flag as well which sets its status based on where there other stages are at. This Master Flag will…
