Hi there,
I hope someone can help me. I am trying to make a spreadsheet where on the
first page I can have all my data, and if I input "true" in one field the
information that follows can be automatically transferred to another page.
For example: If I am doing a expenses spreadsheet, and if I code a column
(joint expenses) "TRUE" it will carry forward to a section I have specified
for joint expenses. That way one sheet can be designated for all expenses,
and one sheet can be coded as joint expenses. I thought of the formula:
=if(sheet1!c4=true, sheet1!d4:sheet1!g4=sheet4!c:sheet4!g4), but it doesnt
work.