=IF(AND formula returning "invalid Operation" error

terri.white82166

terri.white82166 ✭✭

10/21/19 edited 12/09/19 in Formulas and Functions

I have several check box columns. When all are checked, I want to turn on a flag in another cell.

I first tried testing two of five check box fields and Smartsheet returns "invalid operation"

=IF(AND(COI:COI = "1", EFT:EFT = "1"), "1")

What am I doing wrong?

Tags:

0 ·

Comments

L_123 ✭✭✭✭✭✭

10/21/19

=IF(AND(COI@row = 1, EFT@row = 1), 1)

0 · Share on Facebook Share on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

Inventory Formula Question
I am trying to keep track of items we have to give out to community members. Mostly I am just making sure I know when I'm getting low on a certain item. I made two sheets, one with the name of each unique item and one with more details that allows me to keep track of the person and date the item was given. Those details…
Find the latest time entry and send a reminder if theres no entries in the future
Hi. I have built a form for our HR department to log their whereabouts for the following week. The team also receive an automated reminder every Wednesday to submit 5 entries (one row = 1 day) for each day of the following week. They simply advance the date field and select their whereabouts for each day. Although this is…
Is a blank date cell "not in the future"?
Working with automation, conditions, where date field is set to "is not in the future". How does that work with a blank field? Is a blank date field considered "is not in the future"? Or do I need to add an "or" date field "is blank" to this? (same goes for "is not in the past".