-
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?
-
Prevent users from entering dates that put other tasks in the past
Our project managers are responsible for creating new projects in our schedule. They enter a install start date and contract date. The dates for all the other tasks are formula driven from the install date. The image below shows our engineering tasks. Those 3 projects where entered within the past two days. All of our…
-
Widget filter, IF statement, or what?
I have a dashboard that provides counts of certain data. One of the counts needs to be date-driven in the respect that it needs to show the count for the current year. How do I build that into the widget?