Currently, I have a formula in place to indicate R,Y,G Health based on the Start/Due Date. Is it possible to add an =OR function so that if "Status" column is switched to complete the Health will indicate green.
Sorry .. very new to this.
You are missing the 2nd "If" in bold:
=If(Status@row="Complete", "Green", IF([Due
Adding an additional IF statement to the beginning of your formula should work.
You will also need to add an additional closing parenthesis at the end of the formula.
IF(Status@row = "Complete", "Green", + existing formula + additional )
Hope this helps!
Thanks for your reply! Is this the way it should be written? If so I get a unparseable error. Thoughts?
@ker9 There it is. Thank you so much!
Create and edit formulas in Smartsheet
Formula combinations for cross sheet references
Smartsheet functions list
Hi everyone, I have one of those pesky formulas that is giving me a hard time. This is for a Summary Sheet I'll use to build a dashboard so I'm referencing another sheet with the data. Here's what I am trying to pull...Count if the following is true: 1) Project name is the same as the project in the summary sheet 2) Month…
I am trying to calculate two fields in SmartSheet (a dollar amount by a tax percentage in decimal format). I then would like to divide the calculation in half. For example, I would like my hotel rate $109 times the tax rate of 12% to be multiplied together to get the total hotel rate and then divide that total rate in…
This might be a silly question but I'm stuck...a little rusty! I am trying to do a count formula for a dashboard that has a summary of how many sites are activated using this column whenever it's starred. The formula will be on a separate sheet used for dashboard metrics. Is it =COUNTIF(Sheet reference), HAS(@cell)) I know…
©2024. All Rights Reserved Smartsheet Inc.