-
Edit contact display?
Hi Do you know if you can edit the display of a contact in an assigned to column? Ideally I just want to see the initials in the icon and not the name/ email that follows. Thanks, Jo
-
Join Formula with Dates - How to eliminate the time stamp?
I am using the join formula to combine the task name, start date, and end date into a single column that will be used for reporting purposes. The start and end dates are formatted to only show the date, not a time, however when I use the join formula, it's giving me 'Task Name -- ##/##/## 8:00 AM - ##/##/## 4:59 PM" and I…
-
Conditional Formatting: Changing Cell Color Based on 3 Separate Date Ranges
Hello All, I'm trying to set up conditional formatting where colors change based on how many days they are away from an automatically generated reference date (Helper Column). Currently I have it set up so that in when the reference date is in 15 days, the "date certified" column will turn yellow, in 5 days it will turn…
-
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…
