Is there a way to have text repeat all the way down the primary column?

Alicia D · 01/25/24

Is there a way to have text repeat all the way down the primary column, even when new rows are added without having to manually enter? I am trying to use this as a helper column so this is what displays in the calendar.

Screen Shot 2024-01-25 at 9.46.33 AM.png

Andrée Starå · 01/25/24

@Alicia D

Excellent!

You could add something like this and convert it to a column formula. (It would show Paper Check Due on each new row)

="Paper Check Due"

I noticed now that it's not possible to use a workflow to change the cell in the Primary Column, so the best option is probably the first option.

Would that work/help?

✅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å · 01/25/24

Hi @Alicia D

I hope you're well and safe!

You could create a column formula that populates each cell with the same text or use a workflow to fill in the cell each time a new row is added.

Would any of those options 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!

Alicia D · 01/25/24

@Andrée Starå , both of those options would be great! Could you walk me through how to do both?

Netty99 · 01/25/24

https://community.smartsheet.com/discussion/116175/is-there-a-way-to-have-text-repeat-all-the-way-down-the-primary-column

You could also just create a drop-down box with that as the answer and make it "default", then each new row it will be added automatically.

Andrée Starå · 01/25/24

@Alicia D

Excellent!

You could add something like this and convert it to a column formula. (It would show Paper Check Due on each new row)

="Paper Check Due"

I noticed now that it's not possible to use a workflow to change the cell in the Primary Column, so the best option is probably the first option.

Would that work/help?

✅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!

Alicia D · 01/26/24

Thank you @Andrée Starå , that worked! Do you know if it is possible to do the same with the date column, except have it repeat every 6 months by examples. Weekly, yearly, examples like that? I would like for the due date column to go all the way down as well without me having to manually enter it.

Screen Shot 2024-01-26 at 8.16.21 AM.png

Andrée Starå · 01/27/24

https://community.smartsheet.com/discussion/comment/415929#Comment_415929

Excellent!

Happy to help!

If you're using dependencies, you could use the same duration on each row and then have the predecessors go from row to row.

Another option is to add the pattern somewhere (I added a sheet summary field) and include a formula in the end date to reference it.

Something like this. (Add = before the formula)

Screenshot of Arc at 27 Jan 2024 at 11_41_23.png

Make sense?

✅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!

Alicia D · 01/29/24

@Andrée Starå , thank you for the help. I have gone ahead and created a sheet summary. Although I am struggling to figure out the formulas in the due date column. I have also enabled dependancies, but I was not sure about next steps for that as well. Would you be able to walk me through both of your options above? Apologies, I am pretty new to smartsheets!

Screen Shot 2024-01-29 at 8.51.11 AM.png

Screen Shot 2024-01-29 at 8.51.01 AM.png

Alicia D · 02/02/24

Hello @Andrée Starå! I wanted to follow up on the above comment to see if you would be able to assist.

Is there a way to have text repeat all the way down the primary column?

Best Answer

Answers

Help Article Resources

Categories