#### Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

# CONCATENATE Formula Help

Options
edited 12/09/19

First, I had the following formula to return the number of tasks marked done over the total number of tasks (i.e., 10 / 50 complete) , then realized Smartsheet did not support the CONCATENATE function.

=CONCATENATE(COUNTA(\$[Done]\$2:\$[Done]\$51) "/" COUNTA(\$[Task Name]\$2:\$[Task Name]\$51)," completed ")

So, then, I tried the following formula, and received a Missing or Invalid Parameters error message. Any ideas or help with my formula?

=(COUNTA(\$[Done]\$2:\$[Done]\$51) + "/" + COUNTA(\$[Task Name]\$2:\$[Task Name]\$51)," completed ")

Tags:

• ✭✭✭✭✭✭
Options

Hi Lisa,

try this:

=(COUNT(\$Done\$2:\$Done\$5) + "/" + COUNT(\$[Task Name]\$2:\$[Task Name]\$5) + " completed ")

• Options

It works. Thank you so much, Dietrich! You made my day.

I also noticed I had the column names reversed. Final formula below

=(COUNT(\$[Task Name]\$2:\$[Task Name]\$300) + " / " + COUNT(\$Done\$2:\$Done\$300) + " completed ")

• ✭✭✭✭✭✭
Options
• Options

Actually, a few edits. The Done column is a checkbox column, so I only want the formula to count the number of boxes checked

=COUNTIF(\$Done\$2:\$Done\$284, 1) + " / " + (COUNT(\$[Task Name]\$2:\$[Task Name]\$284) + " completed ")

This discussion has been closed.