-
Conditional formatting based on attachments, comments, un/locked status, etc.
Hi Smartsheet, I'd like to see the ability to create conditional formatting based on if a row has attachments, comments, is un/locked status, etc. These features are in the "side margin" on the left hand side. ie. If a row contains an attachment change the font to BOLD. ie. If a row becomes locked highlight a cell a…
-
When a copy row automation is triggered, is there a way to only copy certain columns/cells?
When a copy row automation is triggered, is there a way to only copy certain columns/cells in that row? I saw in a post from 2020 that this was not possible yet. Is this possible now in 2023?
-
Cell Value Capture for Monthly Reporting
Hello, I am trying to build an executive summary dashboard and would like to capture cell values at the beginning of every month to compile on a monthly basis. I have thought about using a row copy automation however i need to build a "capture sheet" for the dashboard to reference for several data points (total invoice…
-
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…