-
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
-
format row with color on date
i have two columns, one is today date collumn and other is review date coloum , if my review date was 20-12-2016 and it today date is 21-12-2016, and it expired i want full row colour changed format and receive reminder setup. thanks you
-
Report selections not working correctly
Hi all, really scratching my head here... ...I'm a fairly proficient user, but am getting the following problem. If anyone has any ideas I'd really appreciate it. I have a set of individual projects with extensive links into a master log sheet. Off this log sheet I have report that select for who the tasks or projects are…
