-
How to compute Average Ratings on a Subset of Rows
Trying to put a formula that will compute the average rating based on organizational grouping. I have a smartsheet that has a drop down field which includes organization functions like: engineering, IT, Sales, Marketing, ... I have another field that is a numeric rating for these organizational functions. 1 thru 5. I need…
-
Automated Alerts & Actions
OH MY! You all are so close... I've been waiting on the day that I could save my alerts and notifications to a template for over a year now. On average, I create about 10 new sheets every week, and each sheet consists of 2 REMINDERS and 8 NOTIFICATIONS. We use these sheets to track new parts to be manufactured, and once we…
-
Filters
Hello, I have a Master sheet setup w Task Names being my customer column. From that I have filters setup for each of my processes which is in the Assigned Column. The filters for example will show all the jobs on the finishing calendar. What I would like to do is setup a filter that would show all the processes for one…
-
Multiple Event entries in Published Google Calendar
I've already submitted help to Smartsheet support, but I thought I'd reach out to the Community to see if anyone else has experienced this and what I can do to fix it. I'm fully aware of the limitations of publishing a Smartsheet calendar into Google and have tested it many times. Recently, my department released a sheet…
-
Conditional Formatting using python API
Are there any examples of adding conditional formatting to a sheet using the python API? Google search did not turn up any. Thanks, Paul
-
Link out to <Unknown Sheet>
Hi, Recently a number of links between two sheets that I use have been broken. It is not consistent (not all of the links were broken). Are there guidelines on why links could have gotten broken? Thanks, Brent
-
Numbers out of sync
Does any one know why sometimes the automatic numbering system becomes out of sync as shown in the attached picture? Thanks in advance Sharon
-
Templatizing
I have an extensive project plan with 250 sub-tasks, which is maintained separately for every client. As 95% of the task list for every client rollout, and the time allocated to every task remains the same; is it possible to automate this process i.e. I simply enter a start date for the project, and each and every task in…
-
Formula Help
I have the following formula in a cell =([Actual Case Rate Achieved]57 / [Expected Hourly Case Rate]57 * 1) This data in the cells "Actual Case Rate Achieved" & "Expected Hourly Case Rate" are not always filled in at the same time, so when information is missing I am gettignthe error "#invalidvalue" I would like my formula…
-
Summary for Notification
Hi, I have the column call "mail out". I also have a column call "date to upload". If we need to mail out financial reports to customer, then I will "mail-out" in the column and put the date for date to upload. Then I set up the notification, as there is "mail-out" in the cell and "date to upload" has the date info,…