-
Conditional Formatting Behaving Unexpectedly
Hi, I have not been able to figure out what to change to get the conditional formatting in the sheet, per the second rule, to dynamically change as time passes and/or the status changes. The red font is not changing back to black when the End Date becomes in the past, and/or the status column is changed to Complete. Thanks…
-
How can I visually group rows together using automation?
I am in the process of moving information from Google Sheets to Smartsheet. I would like to automatically apply formatting to a group of rows to indicate that they belong together. In Google Sheets, I would use borders to separate orders. This would indicate to my team and a group of items belonged to the same order…
-
Automation
Hi everyone, I need to delete duplicate rows in a sheet. How can I create an automation to delete one of the "n" duplicate rows? How can I create an automation that deletes a row completely under specific conditions? Also, is it possible to highlight duplicate rows with conditional formatting? Thank you!
-
How to add column that shows start/finish time in minutes?
I see you can list a task in minute increments, e.g. 15min. We are creating a cutover plan and need to list a start & finish TIME: e.g. 9:00, 10:00, etc. Does Smartsheet have this as an "intelligent" column or just a text/number one only? Would be extremely helpful, so that folks can time the work and also, if you add…
-
Symbols for Multiple Columns or Adding Conditional Formating
Hi, Is there a way smartsheet can make it easier to apply conditional fomulas on multiple rows that meet the "N" = red and "Y" = green, rather than having only a format that can let me select multiple columns to the same color when 1 column has a "N" and setting a new rule each time I want to have "N" be red in a different…
-
Conditional formatting with dates
I want to add conditional formatting that is triggered if a date is more than 2 days old. Which of these criteria should I select? Is this possible?
-
Is it possible to restore or review deleted conditional format rules?
We deleted a set of conditional formatting rules but now I wish we had them documented.
-
Help getting the summary of my sheet
I am not getting the result I need from a formula I am using. I am trying to track how many audits are completed and how many are left to do in total for this quarter '__ of ___ done', currently I am using this formula: =COUNTIF(CHILDREN(Done2:Done130), 1) + " of " + COUNT(CHILDREN([Task Name]2:[Task Name]130)) + "" + "…
-
how to alert contacts in the row when the Planned date is about to reach?
What process should we use to automatically alert the contacts in that row about the status 3 days before the PP planned date?
-
How to highlight the values in the column which is greater than or less than the other column values
Suppose, the order quantity we have taken from the customer is 500, and the quantity we have placed an order with our supplier is 600 how to highlight this excess quantity?