Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

We need Two Cells to Trigger a final cell location

MATRIX Architect
MATRIX Architect ✭✭✭
edited 12/09/19 in Archived 2017 Posts

We need 

When Med4 Quiz is checked and Med4 E Learning is checked, then All Complete needs to automatically check.

I have tried =IF(AND([Med4 Quiz]3 < 0, [Med4 E Learning]3 < 0), 1, 0)

...but this is not working for me. Any help with this would be greatly appreciated!

Smartsheet Formula Question 11-22-17.JPG


This discussion has been closed.