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…
Currently Triggering recurring workflows are only supported at the top of each hour. For instance 10:00, or 11:00, etc. Would like the ability to set 10:30 or 10:45. Perhaps the inteface can stay hourly so it doesnt get huge, but have the ability to manually edit the time directly to any custom time.
I have an automation that has a condition where I am looking at the column "LEA Interco Supporting Site(s)" and trying to find columns that have the value "Fort Loramie" in them. This works well when "Fort Loramie" is the first item listed in the cell, but it doesn't work when "Fort Loramie" is the second or third value in…