-
Forumlas that have shading to alternate every other row which also update when rows are deleted/adde
Good afternoon! I did use a pair of formulas based of digging I did on the forum, both a =ISODD and =MATCH, with an AUTOID column, but I think I'm making it harder. This sheet is based off a form which will add a row per submission. I'm wanting to alternate the shading every other row via conditional formatting, which it…
-
Conditional formatting for dates that are X amount of time in the past
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…
-
Barber pole and crosshatched backgrounds
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.
-
Conditional formatting
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
-
Recurring Tasks
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…
-
Document Generation/Dynamic Views & Conditional Formatting
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...…
-
How can we have a drop down in Dashboard
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
-
Removing Duplicates from a Report
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…
-
conditional formatting for Duplicate Values
Excel have Conditional formatting option for highlight the duplicate values. Does this currently exist as an option for Smartsheets or could this be added?
-
Auto Sequence by Date?
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…
