Dynamic View - Field Logic Work around

Silvia Rangel

hello Smartsheet community!

l am building a Dynamic View with some Field Logic added so whenever the fields meet certain conditions, the field is visible in the details panel. I know that field logic only works with Dropdown or Symbol columns, however the data fed in to the sheet is entered manually (free text). Is there a work around (helper column, formula, etc. ) that will pull free text fields into the logic field selection??

thanks!

Andrée Starå

Hi @Silvia Rangel

I hope you're well and safe!

Yes, I think it should work if you create a helper column (dropdown) and either use a formula to change the value or a Workflow referencing the free text cell.

Make sense?

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 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 @Silvia Rangel

I hope you're well and safe!

Yes, I think it should work if you create a helper column (dropdown) and either use a formula to change the value or a Workflow referencing the free text cell.

Make sense?

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 or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Silvia Rangel

Thanks @Andrée Starå , it works!

Andrée Starå

@Silvia Rangel

Excellent!

Happy to help!