Is there a way to apply logic to a form that when asked at the end if they have another record to input that they can fill out the questions again but some fields do not need to be completed again such as name?
Hi @Marlies Bloxham
I hope you're well and safe!
I developed a solution using two forms (or the same form by using conditional logic) that can be used to submit the main information and then the other information on a new row for each submission after the first.
Would that work/help?
I hope that helps!
Be safe, and have a fantastic week!
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, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Hi @Andrée Starå thank you for your quick reply. Yes using the conditional logic on the same form is what I was hoping to do.
Thank you, and have a great week yourself.
Happy to help!
If you want, I'd be happy to share an example.
Please email me at [email protected], and I'll share it with you.
✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
@Marlies Bloxham Please upvote my enhancement request for user-selectable sticky form response fields!
Jeff Reisman, IT Business Analyst & Project Coordinator, Mitsubishi Electric Trane US
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
@Andrée Starå I will email you. Thank you. @Jeff Reisman I did upvote. Your enhancement request would be really helpful!
@Marlies Bloxham Thank you!
Hello. Trying to make a quick attendance tracker for a meeting. I got conditional formatting to change the cell color when its checked vs unchecked. However I cannot seem to find a way to get the rule to apply to multiple columns on a per column basis. I need a way to copy what I have for column 3 and apply it to all…
Hey Smart Heads, I have another question about our beloved topic of formulas. Background: I have a autogerated column with row created date. In the file, rows are added in 2 ways: In bulk, by senior auditor Ad-hock by auditor I would like to diferentiate these two types of inflow. I came up with an idea of finding…
What I intended to do is super simple: bring two sheets into one Row Report and do a simple pie chart on the status field. -> Source Data: two sample sheets A&B have exactly same fields. and the status is a dropdown list with single value -> The roll up row report, only picked the status field from the two source sheets.…
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.