Trying to get my column to display same text in every cell within the same column each time

Matthew R

Good Morning SmartSheet Community,

Having a little trouble writing a formula that auto-fills every cell in a column with some pre-determined text.

Trying to get every cell in the IT column to read "C - Coded" as soon as we begin working within a new row.

Perhaps no formula is needed?

Thank you for any help you all can provide!

Andrée Starå

@Matthew R

Happy to help!

Try this.

="C - Coded" and convert it to a column formula.

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Andrée Starå

Hi @Matthew R

I hope you're well and safe!

You could use a column formula, but you could also use a Workflow combined with the Change Cell Action.

Would that work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Matthew R

Any recommendations on a column formula to use?

Current formula is only @row, does not allow me to @cell with this formula type.

Again, thank you for your insight.

Samuel Mueller

@Matthew R have you tried just using the formula

="C - Coded" and turning that into a column formula?

Andrée Starå

@Matthew R

Happy to help!

Try this.

="C - Coded" and convert it to a column formula.

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Matthew R

WOW, I did not realize it was that simple.

Here I was searching for a specific formula that would accomplish that.

Works perfectly and I have learned something very useful for our program where I work.

Can not thank you all enough to be honest.

Andrée Starå

@Matthew R

Excellent!

You're more than welcome!

✅Please support the Community by marking the post(s) that helped or answered your question or solved your problem with the accepted answer/helpful, Insightful/Vote Up/Awesome. It will make it easier for others to find a solution or help to answer!