-
Email notification with parent row are illegible!
Hello from Hamburg Germany, Unfortunately we receive the content in the email notification with the parent row illegible! On the other hand the email notification without the parent row is just perfect >> see the comparison 😏 How we can get the email notification with the parent row in the same style as the email…
-
Conditional Formatting Date Range
Hi! I am trying to conditionally format a row if the date range of Start and Finish columns contains today's date. In the example below, I would like "Pilot Run Material Prep" to automatically highlight and for it to adjust as we move through a project. It seems I can only conditionally format the Start column for a…
-
IF AND Statement for Color Statuses
I am trying to do something that I thought was fairly simple, but I keep running into an issue and receive an "#Unparceable" with my current formula. I am trying to build a Task Status based on Red, Yellow, Blue, and Green Circles. My challenge is getting the proper formula/syntax for my Yellow Status. =IF([Status]1 = ???,…
-
Multiple columns condtional furmola/formate
Hi , I have fleet of cars my drivers manually on daily basis type the KM/Millage reading in Column (Km/Today) I need formulla for column Alert as follows: - - - - - - - - - - - - - - - - - - -- - - - If number in col (Oil Next) is less than col ( Km/Tiday) the alert Col is (Green) AND If number in col (Oil Next) is Higher…
-
Cell formatting issue
Hi, I seem to be having an issue with cell formatting. I have set up formatting for cells to turn red/green, I then added a rule to make the whole row white if the date in the date column is in the future... For some reason although the white row rule is at the top it is not applying this above the others? Thanks, Will.
-
Formula to Link PTO Tracker to Project Schedule
Hello, I have created a PTO tracker to log my project team's PTO during the project lifecycle. The PTO tracker that I created is a separate sheet from my project schedule. Is there a way that I can create some conditional formatting (maybe via a checkbox helper column) to link these two sheets and indicate where there is…
-
Need to identify who responded in the survey
I have two sheets. Sheet A is the master list of the names while Sheet B is the list of the respondents of the survey form both containing the unique identifier code. I need to identify who has and has not yet responded to the Smartsheet form. Questions: Is there a way to automatically mark Sheet A when a person submits…
-
Conditional Formatting
Hi, I need to apply conditional formatting based on another row in the sheet. Higher it should be highlighted in red, equal to or below highlighted in green. It would be easy to just use the target figures in the conditional formatting rules but I need to be able to change it frequently without changing all the formatting…
-
If Imported File Contains the Same Value in a Field Multiple Times Automatically Create Children
Okay. This is super hard to explain. Here it goes, I will be importing an excel file to smartsheet through zapier. One header field is called "Reference". I will be importing orders, and how it exports into Excel, each individual product on ONE order will have the same Reference number. For example, 5 rows might say…
-
Countif date is in the next 30 days
Can a COUNTIF (or other formula) count if a date is in the next 30 days or is in the past compared to the inspection date? I have conditional formatting flagging this, but would also like to count how many date violations there are as I will eventually add more expiration date columns. I have only been able to figure out…