-
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…
-
Configurable Editor rights at user level
Hi Smartsheeters Has there ever been a request for configurable Editor rights at user level? At present, (non Admin) users are either Editors with read/write access to the whole sheet, or just Viewers (read only). Beyond that, the only extra configuration of editing rights is to lock columns or rows to prevent all Editors…
-
How to track new Smartsheets
Is there an easy way to track new sheets created? I'm the account admin, but other users want to create sheets as well. My problem is tracking those new sheets to ensure they adhear minimum standards. Thoughts? Jim