If, then Formulas in coda

1

Hello Everyone!

I am using Coda to track requests and approvals over those requests. I’m using a table were I have columns for the approvals. I would like to create a formula that gives me a answer if all approvals have been received. For example:
If approval A and Approval B columns = True, then result is True. any other combination is False.
is this possible in tables?

Thank you,

2

Yes, absolutely.

There is an if() formula in the Coda formula language that you can use.

P

1 Like
3

How that I am back at my laptop, here are some examples of how the formula works. Please search for if():

P

2 Likes
4

All() is a relatively new formula that I think it can help you.

4 Likes
5

Also check out SwitchIf(), which lets you do multiple if statements at once that don’t necessarily have to be true or false:

1 Like
6

Sounds like you’re looking for something like this:
ALL( Table.ColA ).AND( ALL( Table.ColB ))

or you could write it like this:
AND( ALL( Table.ColA ), ALL( Table.ColB ))

1 Like
7

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.