If you have created conditional formatting to color alternating rows a different colors, how do you format the document to automatically adjust colors when a new row is added?
We keep a list of Completed tasks. Based on the date in the Work_Ended column, I would like to autmomatically move rows > 90 days old onto another sheet, which we'll call Completed Archive. Is there any way to automate this process? Thank you!
Can I upvote for Database Normalization? Many colleagues and I are using Smartsheet daily and are starting to implement it company-wide. One thing we'd like to do with it is use like a database. That said, it would be great if there's some capability of assigning primary and foreign keys.
Has anyone heard of when some of the new features will be in production? What would be amazingly usefull are: Card view Conditional Notifications Web forms that allow for different pages or conditional logic More printing options
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/ https://www.smartsheet.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),…
