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
Options
MATRIX Architect
✭✭✭
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!
Tags:
Comments
-
I think you got your < symbol backwards. You want to check if its GREATER THAN > 0
=IF(AND([Med4 Quiz]3 > 0, [Med4 E Learning]3 > 0), 1, 0)
This discussion has been closed.