Autofill columns with N/A

Cristian

Hello

I am in need of a formula that would fill several non pertinent columns with N/A.

Example: I have a column (Category) if the drop down selected is Speaker Engagement, then fill the following columns with N/A:

Update

Comms plan

Intake form

Dry Run Date

Review Date

Thanks for the help

Andrée Starå

https://community.smartsheet.com/discussion/129459/autofill-columns-with-n-a

Hi,

I hope you're well and safe!

You could use a Workflow trigger the change instead of fomrulas.

Would that work/help?

I hope that helps!

Be safe, and have a fantastic day!

Best,

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

✅ Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Aweseome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!

Cristian

Hi Andree

Yes I can, but I was just wondering if there was a formula of such.