-
IF Formula Question
Hi there, I am kind of new to SS formulas and I am trying to create a function that adds an amount to a column IF that column is a certain deal type. The columns that I need the addition to are labeled "Development WAG $" and "Implementation Costs $". IF the "Deal Type" column has "Lease/ Purchase" I need the $350,000 to…
-
Timestamping
Hello. Is there currently anyway to do timestamping in Smartsheets? For instance, timestamping a cell when a tick box cell is ticked? Thanks Andrew
-
Default Conditional Formatting and Options, is it possible?
Hello everyone, Is it possible to add a default Conditional Formatting to every existing sheet and every new one.? I would also like to set the Options % Complete column to always be set as % Complete. Is that possible or the way is to do it individually?
-
Formula for calculating today minus the case created date
Hi, I'm a new user here. What is the equivalent formula from google spreadsheet to smart sheet if for example, C2 is the cell with Case Created Date? =TODAY()-C2 I'm trying to show the actual case age without including the weekends and holidays. Thank you in advance for the one who will answer.
-
Set up conditional formatting in dates, with additional variants
I know how to set the conditional formatting to have a date cell turn red when the task is due in the next X days (for example). But is there a way to do it only if the Status (another column) is not in "Complete"? So something like: If Status is "In progress", "In review", or "Not Started", AND Due Date is in the next 2…
-
Conditional formatting to highlight attachments on a row
As the attachment (paperclip) column is on the far left of the sheet and can't be repositioned, it's not always clear when an attachment has already been added to a row (as I often don't scroll far left to check, especially in sheets with multiple columns). Is there an easy way to use conditional formatting to identify and…
-
Formula to check a box depending on start & end date
Hi all, I have 2 date columns (start date & end date) and 2 checkbox columns (live & concluded). I want to have the checkboxes automatically check and uncheck depending on the dates. For example: I have an event that runs from 12/2 through 12/4. On 12/2 I want the "Live" column checkbox to check and stay checked until the…
-
Inconsistent Conditional Formatting
Hey Community! I'm wondering if someone can help me out with why conditional formatting is not giving me consistent results. As shown below, I would like to see red text when the Unbilled column is not zero. One section is returning red text for $0.00 and another section is leaving it black (which is what I want). The 3…
-
Conditional Formatting w/ criteria in a row vs a column
Hello, I have a grid with a row at the bottom that has either 100 or 0 in each column. I would like to create a conditional formatting rule that will highlight the column based on data in that single row. Conditional formatting rules look at criteria in columns rather than rows so I am wondering if anyone has come across…
-
how to get the circle quarter symbols to change colour???
Ok so I am using the below symbols with a formula in background to be in different qtrs/ stages of a project.... Background Formula is: =IFERROR(IF([%]@row <= 0.01, "Empty", IF([%]@row < 0.26, "Quarter", IF([%]@row < 0.51, "Half", IF([%]@row < 0.76, "Three Quarter", "Full")))), "") However, I want to change the colour as I…
