Carriage Return within a Cell - COUNTIF

Options

I have read in other discussions that you can put in a carriage return to JOIN or COUNT through a work around by adding another column. I have tried this with a COUNTIF and I can't get it to work.

My original formula had a comma between the results: ="Exceptional Performance = " + COUNTIF(Accessibility2:Accessibility6, "Exceptional Performance") + ", Good Performance = " + COUNTIF(Accessibility2:Accessibility6, "Good Performance") + ", Mediocre Performance = " + COUNTIF(Accessibility2:Accessibility6, "Mediocre Performance") + ", Poor Performance = " + COUNTIF(Accessibility2:Accessibility6, "Poor Performance")

My updated formula after I added a column titled RETURN: =".Exceptional Performance = " + COUNTIF(Accessibility2:Accessibility6, “Exceptional Performance”) + Return2 + "Good Performance = " + COUNTIF(Accessibility2:Accessibility6, “Good Performance”) + Return2 + "Mediocre Performance = " + COUNTIF(Accessibility2:Accessibility6, “Mediocre Performance) + Return2 + "Poor Performance = " + COUNTIF(Accessibility2:Accessibility6, “Poor Performance”)

Am I doing something wrong or will it not work with a COUNTIF?

Thanks - Sharon

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!