Sign in to join the conversation:
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!
Has anyone found a workaround for sharing Smartsheet reports externally without giving access to internal data? I currently have to download the data and transfer it onto excel to create a pivot table for our client and I want to find an easier way to do so. I also already create a dashboard for our client, but I wanted…
Hello team! Hope you all are having a wonderful holiday season. I am trying to set up an automation that will send an email reminder one time when Next Update Date = 60 days, then another automation at 30d, etc. The key is I only want it to send the reminder one time when Next Update threshold is reached. Is this possible?…
I have an automation setup to escalate to managers when a step goes beyond 2 days. I have that titled as Escalation for Purchasing, Escalation for Planning, etc. In my trial run, 3 out of 6 showed up as Reminder: New part number request log ( this is the name of the sheet) The only thing we could see was that the ones that…
