The ability to apply conditional formatting rules from within a report would be huge. Having to modify the Source sheet for a specific report doesn't seem to be very efficient.
I have a sheet that is refreshed every morning to add and update existing data from an in-house data warehouse. I am trying to create a sheet that pulls from the original sheet and can produce a graph in dashboard that tells me how long something has been in a current state, with many things being in that state for various…
Currently there isn't a way to color code cards/line items in the SmartSheet app. This would be a huge help for triaging tasks to the correct group as its easier to identify a color than a small text on a handheld device.
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…
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...…
The ability to format cell borders with line style and color.