-
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...…
-
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…
-
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…
-
Lower Conditional Formatting Rules Taking Priority Over Higher Rules
Hi, I'm working on a sheet with conditional formatting now. I have two rules that specify font characteristics. The top rule specifies bold font, and the lower rule specifies strikethrough. When a row meets both rules' criteria, the font is both strikethrough and bold, while I want the font to be just bold with no…
-
Merged: Is it possible to simplify the process to set-up a reoccurring task?
This discussion has been merged.
-
Need help adding a 3rd argument to a COUNTIFS formula
Hello, I am trying to count number of late documents within a specific section of the sheet. I have been able to do it successfully using row numbers but we change rows frequently because it is a roster type list I don't want to have to edit the formula each time. The third argument I wanted to use was to use their teams…