Sign in to join the conversation:
I need for a text box to appear only if "OTHER" is chosen from the dropdown menu. Can a field (text box) be hidden unless OTHER is chosen?
Hi Kitty,
Unfortunately, no it can't be hidden but depending on your need it could be shown in another color or similar if other is chosen.
Would that help/work?
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
That will work! Thank you!
Andree, I'm following this thread because I'm trying to do something similar. My drop down list criteria in my form are the following "Acceptable" "Unacceptable" and "N/A". I want to have some sort of rule (?) that if "unacceptable" is selected, the user must add a comment. I'm not sure if this solution is the same for me as the original poster. Can you advise?
Excellent!
Happy to help!
Let me know if you need any help!
Andrée
Hi Hilary,
It's a little different when it's in I form because currently, Smartsheet doesn't have any functionality for conditional logic in forms.
There are a few workarounds.
Would any of those options work?
Andrée
Thanks! It seems that the third option would be best. So would this require me to add an additional text field for every question in the form? Currently there are quite a few questions and it is already a long form to scroll through.
I'd add the text in the bottom of the form and maybe add a checkbox or dropdown list where they can select that they've added the comment or that no comment is needed or similar.
Would that work?
Thanks for your help!
You're welcome!
I'm always happy to help!
Hello, I'm working through the writing formulas optional activity and in the 'Nested IF function - Progress Column' task it directs you to put in the following formula '=IF([% Complete]@row = 0, “Empty”)'. However, when I put this formula into the spreadsheet, '04a_Marketing Request Tracker - Formulas', I get an…
Have any of you created a Smartsheet that would show the savings for a project by the month? In other words, if I saved $1200 annually and the project ended in say March, then the savings would go $120 per month, Mar 2025-Feb 2026. I have done it on Excel sheets manually, but I think there should be a way to do it with…
I have had approval workflows and notifications built into a couple sheets for about a year now. In the past month, I am getting a lot of feedback saying people did not receive the email request for approval or notification email. It isn't all the time, just sometimes and there does not seem to be a pattern on which ones…