-
Date Driven row roll off
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!
-
Sheet with Database Normalization (Primary and Foreign Keys)
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.
-
UPCOMING FEATURES
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
-
NEW - Dashboard + Card layout
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…
-
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.
-
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?
-
Conditional Formatting in Calendar Not Working on Refresh
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…
-
Conditional Formatting - Filter odd/even numbers
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.
-
What is wrong with this formula in totaling in parent row?
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),…
-
Conditional Formatting - Track Cost Fluctuation
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…