Hi,
I have a form with Multiple Checkbox and I would like to display Checkbox header if selected. If multiple checkbox selected , would like to display combination of those checkboxes selected.
Pls help at the earliest.
Thanks,
Chetan.
Hi Chetan,
Can you describe your use case in more detail?
Best,
Andrée Starå - Workflow Consultant / Get Done
Thanks for checking on this.
Here is the use case,
I have a smart form where I have checkbox to select TYPE of things. Now in my smartsheet , I want 1 column to display the Selected Option / options from the checkbox selected in the form.
If we are using checkbox means , the user can select multiple options in the form , the same needs to be displayed in a consolidated column in the smartsheet.
How to display this consolidated selections in a column in smart sheet.
what kind of IF formula should i use to say , if Option 1 is selected and Option 2 is selected, Option 3 is not selected, the column used to display this selected options should says ( Option 1 + Option 2).
Hope this explaination helps.
Here is an example on how you could set it up. Would this work for you?
https://cl.ly/p9Ta
Below you have the formulas so that you can copy them easily.
=IF([Doc 1]1 = 1; "1")
=IF([Doc 2]1 = 1; "2")
=IF([Doc 3]1 = 1; "3")
=JOIN([1res]1:[3res]1; "+")
Please see attached link/screenshot.
I hope this helps you!
I have a Smartsheet automation setup to reminder the planning to complete their sections. It is setup to remind weekly until completed box is checked. They received 2 reminders and then the reminders stopped. Any idea what could be wrong? I can't tell that anything has changed in the sheet. Thanks Freda
I'm editing formulas in a Sheet Summary. However, I'm prevented from seeing the formula by an annoying "helpful" popup that obscures my view. I can't figure out how to get rid of the popup. Does anyone know?
I am trying to create a workflow and for some reason it gives me an error with the email I entered as the recipient for my Alert. It is an email that I know works, it is shared to the sheet, and the access to the sheet is unrestricted. I am perplexed at what the issue is. Anyone else get this and know what the issue is?
