Welcome!

Formula with two conditions met turning a ball green

Hello, I am trying to build a formula that will do the following:

If either column is blank the health stays blank.

Formulas

Hi Randy,

I was hunting back through the pages looking for unanswered threads and couldn't understand why this one had been orphaned.

The formula you're looking to stick in the first row of the Health column is:

=IF(AND([Yes/No]1 = "Yes", [Verification Check]1), "Green", "")

Then drag it down as far as necessary.

Kind regards,

Chris McKay

Down Under Smartsheet Support

Counting Distinct Items in Sheet1 from Sheet2
I have a counting formula that's working in Sheet1. When I try to use that same formula in Sheet2 to pull the data from Sheet1, I get an UNPARSABLE error. What am I doing wrong? Original formula (in Sheet1): =COUNT(DISTINCT(COLLECT([Department]:[Department], [StartDate]:[StartDate], >=DATE(2025, 7, 1), [Status]:[Status],…
Cross Sheet Formula For Averaging Total Turn Around Time
I’m looking for a cross-sheet formula in Smartsheet to calculate the average Turn Around Time (TAT) by specific Site Numbers. Source sheet details: Site Number (text/number) Turn Around Time (number; measured in days) Target sheet details: I have a row per site and want a formula in the Avg TAT column that returns the…
Help Needed
Hi All, I am trying to create a formula to work out the number of days ( Helper V1 ) between the VISIT 1 and VISIT 2 days column. Any thoughts would be greatly appreciated Thanks