-
Conditional formatting font color in Card View
Is there any way for font color changes via conditional formatting to be shown on the cards? I have a formula the changes the row's font color red when an end date field is in the past. Unfotunately I can't see these changes in card view, only in grid. Thanks for the help!
-
Smart Header Rows - Feature request
Header Rows that group and/or describe the rows beneath them are very useful (especially in to-do lists) but they could be better in a couple of ways: 1. Allow users to designate rows as 'header rows' that are exempt from conditional-formatting, auto numbering and date-created fields, etc. 2. Allow a line's postion…
-
Conditional Formatting for two end dates
Just to be clear I only have one end date in my sheet. The sheet has a conditional format set up to flag "At Risk" tasks when the end date has already passed. Here's the current formula: IF(AND([End Date]3 < TODAY(), NOT(Status3 = "Complete")), 1, 0) I want to add another condition to flag the task when it is within 5 days…
-
Automatically send a web form (feedback survey) as part of notification alert or conditional formatt
Is there any way to automatically send a web form (feedback survey) as part of notification alert or conditional formatting? I have a sheet with a web form that customers can use to submit requests for service. This sheet is viewable by staff that it is shared to. I also have a customer service feedback sheet that is not…
-
IF () formula, Change Status Dependate on Date
I would like to build a formula so that status will change to "Red" and type will change to "Renew" when date is past "Expire Date". I've applied the two formulas separately at the top of each corresponding column. But so far it just changes it to Red or Renewed automatically, without the date dependency. Can I make this…
-
Blank display value for Symbols type?
I'm trying to recreate a switch function I've used in Project files to work in Smartsheet. It updates a symbol status column based on %Complete, Today's date, and Finish dates. I'm trying to use the green Up, yellow Sideways, and red Down arrows. Issue is, also need to display a blank in that status column if none of the…
-
Inventory Tracking
I'm trying to create a spreadsheet to track inventory for my business. It's very simple but for some reason, i'm having difficulty with the nested IF's. For example: the top of the sheet will list total inventory of wines; Merlot Pinot Chardonnay The user will select a type of wine, enter the quantity taken, and based on…
-
Formula involving multiple IF/AND statements
I need to modify the following formula to include additional AND conditions. =IF(Finished12 = 1, "Blue", IF(Target12 >= TODAY(+14), "Green", IF(AND(Target12 >= TODAY(+7), Target12 < TODAY(+14, "Yellow", IF(AND(Target12 < TODAY(+7),%COMPLETE>70, "Red")))) The additional condition would be in the third if and would be…
-
List totals
I have a sheet that lists all of our clients by project. For reporting, i'd like to see a final report or dashboard widget that lists the clients name in order of most mentions within the original list. For example: List A Joe Doe Freddy Mercury Alice Chains Eddie Money Joe Doe Eddie Money Joe Doe Report: Joe Doe - 3 Eddie…
-
Highlight If Older Than 'X' Days
I'd like to use conditional formatting to highlight a row or cell if it's older than 30 days. It's helpful for us to see which tasks are stale. However, there's only an option for "In the last 'x' days" or "older than (a date)". Has anyone found a good workaround or submitted this as a feature request?