Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.
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.
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!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E: andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
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!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E: andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
@Andrée Starå , both of those options would be great! Could you walk me through how to do both?
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.
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!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E: andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
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.
Excellent!
Happy to help!
Something like this. (Add = before the formula)
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!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E: andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
@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!
Hello @Andrée Starå! I wanted to follow up on the above comment to see if you would be able to assist.
