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.
Discussion List
Conditional Formatting not working properly
Is anyone else having an issue with their conditional formatting not working properly after the most recent updates? My rules have not changed but the formatting is only displaying for some of the rules now. It is mostly occurring for rules that determine cell fill color.
Alerts & Actions
Hi Everyone, I am looking to see if you can set up an alert that will trigger and email say if the dollar value is over 1500. Has anyone run across this? Thanks. J
Report not syncing when columns from source sheet deleted
Does anyone else experience the glitch where the columns on a report that were originally added with the report builder, but then deleted from the source sheet at a later point, are still showing up on the report as orphaned/inactive columns?
Formula puts data left-justified instead of right-justified
I have the following simple formula: =IF([Grasp of Material]3 = "Excellent", "100%", IF([Grasp of Material]3 = "Good", "80%", IF([Grasp of Material]3 = "Fair", "60%", IF([Grasp of Material]3 = "Poor", "40%", IF([Grasp of Material]3 = "N/A", "N/A"))))) The formula puts the 100%, 80%, etc. as left-justified. When I try…
Form Submission Organization in Sheet
Is there a way to automatically move a new form submission to a nest under a particular row? For instance, I have 4 parent rows that nest several rows underneath and would like any form submissions to automatically be assigned under one of those 4 parent rows based on information that's submitted (if this, then nest under…
Auto Cell Linking With Templates
I need a way to auto link a row from new sheets with a master sheet because I am constantly using a template to create new project sheets containing the same info categories on each one but it takes up to much space to have all the projects on one sheet so i opted for individual project sheets. I need to be able to add key…
show the latest date from 3 selected columns
I would like to show the latest date among 3 selected columns in a new cell, Is there any formula to make it happen?
Column Titles
How do I center Column Titles to make my work look tidy?
Functionality Request - Egnyte
It would be incredibly helpful to have full integration and send documents into Egynte's document depository from Smartsheet.
Adding numbers that fall in a date range
Just learning Smartsheet. I need assistance creating a formula that will create a sum based on calendar months. I have two columns: one for a number of appointments, the second is a date column. As an example, I would like to have Smartsheet calculate appointments that fell in December. Thanks for any assistance.
