Re: conditional formula across sheets

It is in MS Excel, I doubt that the current version of Numbers can.

Hi Michael,

This is easily done in Numbers. You can build your IF() formula in the report table, navigate to the other sheet and click the check box, etc.. If you want to ask a specific question about your sheet I will be glad to help.

Csounds' confusion stems from the fact that Numbers does not support links between different documents. That is clearly not what you are dealing with.

quinn

Hi M,

Do you use Dropbox? you could share a link- make sure you don't have any sensitive info in the table.

Or I could try to just walk you thru it. Is is easy.

Start in the cell you want the value to show up in. Type "=". Type "if" and hit return. You will see this:

"if-expression" is already highlighted. Navigate to your other sheet and click on the checkbox in question.

Click on "if-true", it will highlight. click on the cell who's value you want when the check box is selected.

Click "if-false" and enter what you want returned if it is unchecked.

You are done. Easy, amirite? I really like how much you can get done pointing and clicking in Numbers. If you study what you end up with then you start to understand the syntax that each function needs.

An interesting thing you may notice is that if your tables have unique names the sheet does not have to be specified. i.e. UniqueTableName::A2 will work regardless of its sheet. Whereas Sheet 2::Table 1::A2 would be necessary if there are multiple Table 1s.

quinn

Hi M,

Glad to help.

q