-
Labels for RYG Balls
Hello I am sure it is an easy answer, but, I cant seem to find information. Is there a way of having a label associated with one of the RYG balls, ie when the green ball is selected, the next column says 'Active', The red ball would be 'On Hold' etc.
-
Need help with Parent Status
I would like my parent status to be RED when ALL children balls are red, yellow when at least one is yellow, otherwise green. I found this formula below in a thread, but I can't seem to get Parent to RED when ALL are red. Can someone tell me what is missing? Thanks! =IF(COUNTIF(CHILDREN(), "Red") > 0, "Yellow",…
-
Formula for Date column based on status change
I'm looking to create a formula to automatically put a date in a column based upon certain statuses in a dropdown menu. For example, I would like that day's date to populate when the status is 1, 2, or 3 but not 4 or 5 (we have about 10 different statuses in our actual list). Is this something that is possible?
-
Formula to get averages from one column if another column is checked
Hi All! I have 2 date columns, Processing Start Date & Processing Turnaround Time, then a column to show the NETWORKDAYS, (labeled Average Setup Time), of those two columns. Then I have a checkbox column (labeled New Setup)and another column to convert the checks into 1, 2, 3, etc.(labeled Setups). What I need to do now is…
-
Changing the Color of a Font Based on Values
Hi All I'm building a budget sheet and am trying to figure out how to change the color of the font if it adds up to be over budget. For Example: =IF([Column]1 > [Column]2, "Red") But by doing that, it doesn't change the color, it puts in the word Red. Is there a way to do it in Conditional Formatting that I'm just missing?…
-
COUNTIF Does not equal
Hello! I'd like to set up a formula to COUNTIF(Children)<>"app/registration complete" so I don't have to setup a more complicated COUNTIFS (I allow the dropdown to not be restricted to the text options I set up). Can't seem to get it to work. Is "does not equal" possible for COUNTIF in Smartsheet? Thanks in advance!
-
Renewal Date
Hello - I have a column for Purchased Date and a column for Renewal Date. I want the Renewal Date to automatically populate to the following year so we know when renewal is due. What is the best formula? Thanks, Barb
-
Detect if cell value increased or decreased
Is there a way to detect if a cell value increased or decreased compared to its previous value? I've already devised a way to reflect a symbol if the auto-column date modified was today. Now, I want that symbol to vary depending if the value on a cell in that row increased or decreased. Or if there's a way to put in two…
-
#UNPARSEABLE
I am using the following formula to calculate the net days but only if the dates are listed. What am I doing wrong? =IF(AND(ISDATE([Date Received]3085), ISDATE([Processing End Date]3085)), NETDAYS([Date Received]3085, [Processing End Date]3085), "") Thank you much!
-
Formula to ammend task descriptions in a project
I hope I can describe this... I work for a video production company and I create individual projects for each video project we have going. There are general task descriptions I use in the Primary column and I would like to have the actual Client Name -actual Project Name follow at the end of every Task description. Is…
