Best Of
Re: Autopopulate Answers
You could do this by adding a checkbox to your sheet and duplicating your second set of questions.
Set up form logic so that if the box is checked, the second set of questions does not appear.
Then in your sheet, you need 2 sets of columns for the second set of questions (i.e. two delivery address columns). One set would be populated by the form (and can be hidden). The other would contain a column formula that would use an IF function to return the values from the first set of questions (billing address) if the box is checked, and return the data from the hidden columns if not.
I hope that makes sense.
KPH
Re: Complex Form Logic Conditions based on Multiple Fields (AND/OR)
YES, this would be a great to have! Often I need to compare 2 different fields at the same time—and just can't. Which sometimes leads to awkward user experiences in the questions asked on the form.
chelinasr
Proofing acknowledgement
Introduce an acknowledgement feature to the proofing tool that can be used to track who has confirmed that they are aware this specific document exists.
Ryan C
Stop this information pop-up from appearing over the Subject bar
This thing is rediculously frustrating when you ahve to edit notifification subjects en-masse. Not only does it get in the way in the first place, but it forcefully re-appears when you move your mouse back to the subject bar after having moved it away.
Or at least provide an option to close it!
Ryan Catling
Re: Override column formula for a cell
I hope you're well and safe!
Unfortunately, it's not possible now (It's all or nothing), but it's an excellent idea!
Please submit an Enhancement Request when you have a moment.
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å
Alert Automation- Populate Dynamic Column information by Clicking/Selecting instead of {{typing}}
Hi Smartsheet,
Please make it simpler to populate columns in the Alert Someone automation. Clicking from a drop down would be much easier than having to type in the {{ }} and the column names.
Thanks,
Eric
Eric B.
Re: How do you automatically populate columns from a master sheet if a specific item is selected?
This is amazing, thank you so much for this!
One quick follow up, for the PRODUCT column (which will act as a trigger for all of the workflows), how would I populate a list that is pulled from the master data sheet (Product Column)? I know I can just add the products as drop downs, but ideally, I would like to pull that list from the Master sheet, in case any changes occur.
Pops1988
Re: Limit Dropdown Options Based on Cell
@Charlesdavid Allen Do you know if this has been implemented? I need the exact same functionality. If you have submitted an Enhancement Request, please send me a link so I can vote on it. Thanks!
BarbaraHanville
Print Row and Attach PDF Automation
The "Generate Document" feature, which is accessible manually by row(s) as well as through automation involves a time-consuming design process and has the inherit pdf limitation of not allowing form fields to expand to accommodate contents.
The "Print" feature works in a similar manual fashion, which allows a user to manually print a row or rows to pdf, which requires no design work and has no form field size limitations.
The requested feature is to add the option to automate the standard "Print" function as a "Print to PDF", which could be used like the "Generate Document" feature in order to add the pdf to the row or email.
TH601
In Grid View, display the order number of cards (in a card view lane) in a separate column.
When using Card View/Board View, display the order number of the card for a particular lane in a grid column. This column then can be used to sort or rank. Especially helpful for ranking/numbering priorities based on card order. Some users of my sheets will rank priorities by moving cards up and down a list. But when I do reporting, I need that order number in a grid column to properly report.
buccills