Welcome!

Web form entries auto-populated one row below rows containing formulas

Hi, I've created Request management tool, which seems to be working fine. The issue I'm facing, is that when user fills out web form and new ticket is created, entries are not being auto-populated into the rows containing formulas, but one row below instead (which is formula free). How I can fix this?

Thank you,

Edvin

Find more posts tagged with

Comments

Andrée Starå

Hi Edvin,

Maybe the row looks empty but there still can be information. Have you tried deleting the "empty" row?

Can you share a screenshot on how it looks?

Hope that helps!

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Edvin

Hi Andrée, thanks for your reply. I have deleted all rows (except the one containing all formulas), and once new web form request was raised, again it was created below, as 2nd row in the sheet. 1st with formulas still remains blank. Some more details: Columns containing formulas are not the ones being auto-populated from the web form, so there shouldn't be any conflict.

Thank you,

Edvin

Removed 1st blank row, raised another dummy case - works fine. Formulas are auto-populating correctly. There's no need to apply formulas for the entire column, apparently that's the way it works

Andrée Starå

Happy to help!

Best,

Andrée

Andrée Starå

Excellent!

Here's some more information on how it works: https://help.smartsheet.com/articles/1641473-auto-filling-formulas-and-formatting

Conditions That Trigger Formula Autofill

You’ll see formulas populate automatically when you type in a newly inserted or blank row that is:

Directly between two others that contain the same formula in adjacent cells. 
At the very top of the sheet if it’s above two rows that have the same formula in adjacent cells. (This includes rows inserted from a form.)
Above or below a single row that is between blank rows and has formulas.

Best,

Andrée

Sign in to join the conversation!

Quick Links

Trending discussions

Sheet Button on Left of Sheet - Error Message
Could somone tell me what button this error message is referring to? I have an Enterprise plan and do not see anything like a "Sheet" button.
Access to a longer published sheet
Hi! I created a Calander events availability tracker and I attached it to a dashboard that I am creating in Smartsheet. It is now unable to display and a notification appears saying that, "The sheet you are attempting to access is no longer published. Please contact the Smartsheet document owner." I am wondering how to…
authenticator help
I tried to sign into my Smartsheet portal it asked for an authenticator code. I don’t have one and I can’t find the QR code to authenticator to my own Microsoft authenticator app. Can anyone help me?