Cristian✭✭

Thanks Paul. This worked.

The formula works Paul. So, can I get these to show up with the % sign? I tried the % symbol under tools but it provides a thousands for example 18 complete would show up as 1800%.

Thanks Paul It works!!! :)

OK Great. Thanks again.

Hi Danielle Thanks for the feedback. I was able to correct my formula in Data Shuttle and now I get this Every time data shuttle runs, I get 26s. :) I could eliminate that expression with a a Count formula. So for now data shuttle is mostly working. I just recently post this. Maybe you and anyone can help me with this.…

This is the formula I am using in to total the amount in column 2 =COUNT([Column2]:[Column2])

Can you link to Smartsheet? e.g. the source is a sheet and the target is also a sheet?

Hi @Kelly Moore The formula works. Thanks. And thanks for making me understand the concatenating portion of formula. Also, thanks for clarifying the @cell portion. Did not know that. Thanks again.

Thanks. I had a similar formula with the dots. Didn't of matching the color to the background. Thanks again.

The formula goes through but the empty flag still shows up.