Why is my form writing to my Smartsheet but leaving 40 or so rows blank?
I am getting all fields populated correctly but a huge number of rows left empty. It's making a right mess!
Hi @Ben Evans
I hope you're well and safe!
It's because the other rows are "activated." Try deleting them, and that should fix it.
Did that work?
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.
@Andrée Starå thank you. Makes sense. I have a calculation based on submitted values to assign a score. I'm probably applying a calculation to ascribe a score based on the submitted value from the form and this is causing the issue.
Do you know of a way to avoid having to copy the calculation down the rows but still have someone submit a form and have the values scored? (e.g. Yes = 5, No = -2 etc).
Happy to help!
If you have at least two rows before or after with the same pattern, the formulas should auto-populate, but you could also convert them to a column-formula.
✅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!
I am running VLOOKUP to bring a picture located in a specific row cell over a new sheet cell. The issue is that picture comes as a text (picture name). My ultimate goal is to pull that picture into a dashboard, when trying that, just the text comes If I bring picture directly from the smart sheet where picture is located…
Hello- I am trying to remove the item names from the right side of the gaant chart. Is there a way to get rid of those and preferably add other column information instead? I see the settings pop up but there is no option to get rid of those labels. Thank you!
I have a report that is filtered by a particular folder within a shared workspace... everytime I remove items from that folder the report no longer watches the folder, and it turns into individual items within the folder... Is this common behavior? Has anyone else experienced this behavior recently? I want the subfolder to…
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2024. All Rights Reserved Smartsheet Inc.