I have a sheet where I would like one column of dates to be conditionally formatted to show if the date is greater than 5 years in the past. For example, once a record is greater than 5 years old then it must be archived. We would like to easily see when this occurs or be able to create a workflow to move them to another…
Would like to see the addition of barber pole and crosshatched variations to background formatting. This would be beneficial in visibility in conditional formatting for say TBD and Blocked items.
I have two columns in my smartsheet that are dates. I would like to set a conditional formatting rule that says 'If column X is after Column Y then apply this format', is this possible? For example 'If 'Date issued' is later than 'Date Due' apply this format' Thanks
Hello I am setting up a smartsheet that will be used to track all the recurring task we have to do in a year. The frequency at which these repeat vary drastically so I wanted to see how one would format their sheet to account for this. For example I have a task that needs to be done the Monday following all major holidays…
How can I set up a generated PDF document to carry over the conditional formatting from my grid? Can the Dynamic View also show the conditional formatting applied to the grid? This works for reports but I haven't been able to figure out how to set the document or view up to show the conditional formatting in the grid...…
Hi Team, How can we have a drop down in Dashboard My objective is - Say for a example a user want to see just the input related to his/her project he can filter his project from dashboard and view. Thanks
Hello, I have a sheet with many line items, some of which share some columns that have duplicitous information. I would like to pull a report from that sheet to display certain information on a dashboard and, ideally, within the report, run a conditional format to remove the duplicate line items. I am also reading up on…
Excel have Conditional formatting option for highlight the duplicate values. Does this currently exist as an option for Smartsheets or could this be added?
Hello! I am creating a sheet that will house projects that need to be prioritized by date. Although I can sort them myself and number them, is there a way to auto number a column based on the date column? In other words, if I have 10 projects with 10 dates, can Smartsheet apply a value in my "Order" column based on the…
There was one conditional formatting rule that referenced the column in question. I deleted that rule, but still can't delete the column. Would be nice if SS would identify the any associated rules—am I missing something?