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

Cell view history
Is there a way to display for one specific columns cell history display in another column for calculation purpose? I wanted to count each stage from one specific column by getting cell history in separate column to calculate duration. Thank you!
Table View Dropdown Sheet Link is Dropping Zeros
I want to use a list of account numbers in one sheet for a dropdown in another sheet using Table View. When I select the sheet and column in the dropdown menu, it shows the correct column but is dropping zeros. I have provided a screenshot of the reference column and then what appears in the drop down. Any ideas?
Formula help for INDEX MATCH. Or is it INDEX COLLECT?!
I have a holiday sheet for Team Members to log their holidays: Assigned To, Start and Finish Date. A formula has been created to flag the status of when they are ‘On Holiday?’: eg, ‘Holiday Complete, ‘On Holiday’ and ‘Holiday Booked’. Based on this status, an ‘Availability’ symbol also appears Id like to use this…