-
Template Management - Updating Active Projects
Greetings, I saw an older post similar to this subject - but I'll open this one to hopefully garner some fresh information. I use a Template that I've built to start new projects (sheets). On occassion, I'll learn some nifty new feature or functionality that I'll build into my master template. That's great for "from here…
-
Updating RYGB status based on date AND dropdown selection in multiple columns
Hello! I would like for the RYGB status to be updated based on BOTH a due date (I already know how to do the status based on only due date), AND on the selection of a drop down menu in 5 other columns. So: Red is past due AND "completed" or "N/A" are not selected in the drop down menu in multiple columns. Green is past due…
-
Cell Formating
I would like to be able to format individual cells - what is the easiest way to do that? For Example - I have months listed with the forecast for that month and I want the cell font to be red if the forecast goal was not met. However, further down the column - the forecast goal might be higher.
-
Conditional formatting not sticking to exported PDF
Hi, I have a report that looks perfectly fine when viewing in Smartsheet but when exported to a PDF it throws in a grey fill. There is a conditional formatting that specifically says if the "Resource name headers" column is blank, keep that cell white - and it's a higher priority than everything else. Why is this happening…
-
Conditional Formatting on Date is not taking into account local account timezone settings
Conditional formatting using a date, is not taking into account the local account regional settings/timezone and appears to be using a default time zone. As conditions like change the color of a cell if the date in that cell = Today, is still highlighting the cell on the next day. My Time zone is set to Australia/NSW…
-
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…
