How can do multiple logic check, then have multiple values combined into a single cell? I tried something like this but it only give me the first value.
=IF('Auto ITPR'!C4=TRUE,(+comments!C4), IF('Auto ITPR'!C5=TRUE,(+comments!C5)) )
Web Applications Stack Exchange is a question and answer site for power users of web applications. It only takes a minute to sign up.Sign up to join this community