Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums. Archived 2016 Posts
Archives for June 2016
Discussion List
Year Planner Templates?
Does anyone know of a good template for a year-to-view planner? I'd like to also see a list of events too. I've seen it in the templates in MS Excel, but organised for school (mid-year to mid-year). I want to be able to track events coming up (training, exhibitions etc) and who attended. Thanks!
Prevent deletion of rows - enhancement request again
I would like to bring this issue back to the spotlight. Many posts (complaints and suggestions) have arrived in this topic in the past (for instance: https://community.smartsheet.com/discussion/prevent-deletion-rows-if-it-contains-locked-cells). I would really like to see an enhancement that makes rows (data) secured…
Count If Formula to Count if NOT blank
I am trying to create rollup summaries in a large worksheet. For a couple of metrics I need I need to include or eclude certain things based on if a cell is blank or populated. For example - I need to count something for a processor if the Auditor fields is blank. The formula below is working =COUNTIFS(Risk:Risk, SSO4,…
Sorting in a Sheet
When multiple users are in a sheet and 1 user sorts, everyone's sheet sorts. Is there any way to prevent that? Is there a change coming?
Summary in Gant
Hi there, is it possible to get a summary row in the gant like this: I need to know the sum of the lines for the week. Thanks Peter
Symbols not changing based on the value in another cell.
I entered: =IF(%3 > "0%", "Red", IF(%3 > "50%", "Yellow", IF(%3 > "85%", "Green"))) and all the cells are red. Not sure why the formula is wrong! . The icon is in the column "Indicator" and the value is in the column "%". Any help much appreciated
Row properties
Is there a way to apply "row properties", similar to "column properties"? I have an analysis that has customer listed across the top and the rows are the critieria with which they are being evaluated. I'd rather scroll down than across.
Widget Display Order
Is there a way to set the display order of widgets when viewing via a mobile device? When devloping sights what looks good on a desktop quite often displays out of order on mobile screeens of a different aspet ratio.
If Status "Complete" how can I set it to automatically update the color on the RYGG balls?
We would like to do conditional formatting or a function so that when the Status column is marked 'complete', it will automatically update the RYGG Ball color in the column next to it. Does anyone know how to do this?
Calculating date due for Service Level Agreement
I have a date assigned column which would be the date someone entered a case. I'd like to automatically calculate in a due date column the 5 day SLA date, accounting for weekend days. Is there an easy formula for this?
