Is Smartsheet getting ready to release the new dashboard and card layout/view? Looks like they are close. There are a few screenshots within the video and webpage. https://www.facebook.com/smartsheet/videos/10153492657651379/ //www.santa-greenland.com/enterprise/scale These look amazing but I still cannot wait to get…
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.
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?
I use conditional formatting to change the background color of certain items in the Calendar view. Smartsheet seems to have a bug where the conditional formatting works perfectly when going from the List view or Gantt view to the Calendar view, but when I refresh the browser within the Calendar view, the conditional…
Is there a way to filter and do conditional formatting for odd/even numbers used from auto-number? If not, I would like to pose this as an enhancement request.
I have a parent row I just can not get to toal the "Win Ratio" (it is a percent) if there is a ZERO in one of the child rows! It is driving me crazy! The colums are: Phone Calls | Accts Created | Win Ratio The Daily formula works even when there is a ZERO in it... I am using this: =IF(AND(ISNUMBER([Phone Calls]18),…
I have a master list to track the cost of an item. Is there a way to format cells to change the font to Red or Green based on whether or not the value is higher than a previous cost? IE: In 2015 cost was $1 and in 2016 the cost rose to $2. I would want the 2016 cost to automatically turn Green to show that there was an…
I have a webform that collects data for a request, Department, Type, Etc. These are separate columns. I would like to somehow filter the some of the information received into one column, which would then be a code for that particular request. The code is then used in other locations as an identifier. Is there any way to do…
I had to copy and paste a few rows within one of my sheets. When I did, it changed the "Created" date and time to when I pasted the rows. How do you ensure that this column always reflects the proper date, if rows have to be copied and pasted? Thanks K
It'd be handy to be able to add a pattern overlay to Gantt bars. Like these: http://www.webdesigndev.com/wp-content/uploads/2015/02/20-Repeatable-Pixel-Patterns.jpg The use case for us is that we want to color code our bars for who the'yre assigned to, but be able to label some of those bars as having a "fuzzy" deliverable…
