How to combine formulas in a single string

Advm · 03/16/21

Hi I am trying to count data using cross sheet references and a countif formula. I have 13 different sheets, thus will need to have 13 different countif formulas in a single string. In Excel, + works, but does not appear to work here. How can I combine formulas in a single string?

Paul Newcome · 03/17/21

The issue in the screenshot is in the second COUNTIFS. You have your closing curly bracket } misplaced after "@row}" when it should be at the end of the cross sheet reference "Range 1}"

Mark Cronk · 03/17/21

Hi @Advm ,

+ should work. Are you getting an error? Can you share a screen shot of your formula?

Mark

Advm · 03/17/21

https://community.smartsheet.com/discussion/comment/283829#Comment_283829

Sure, "+" does not seem to work. I have 13 different sheets that are different sessions for an event. An employee can register for any of the 13 sessions, thus appear in any of the 13 sheets. I want to be able to count/capture the employee if they are in any of the 13 sheets.

So my thoughts are that using a countif (i actually used COUNTIFS, though not needed) formula to count how many times the employee appears in any of the 13 sheets (it should only be once).

Here is the formula with cross sheet references to only 2 sheets:

Here is the error received:

Ultimately, i'm trying to ensure I can capture if an employee is registered for any session, thus i would need to "check" for that employee's email address in each of the 13 sheets.

Paul Newcome · 03/17/21

The issue in the screenshot is in the second COUNTIFS. You have your closing curly bracket } misplaced after "@row}" when it should be at the end of the cross sheet reference "Range 1}"

Advm · 03/17/21

https://community.smartsheet.com/discussion/comment/283902#Comment_283902

That solves it! Thank you.

Paul Newcome · 03/17/21

Happy to help. 👍️

Mark Cronk · 03/18/21

Thanks Paul! You are the master.

Mark

How to combine formulas in a single string

Best Answer

Answers

Categories