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

edited 12/09/19 in Using Smartsheet
03/30/19 Edited 12/09/19

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

Comments

  • Andrée Starå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

    SMARTSHEET PARTNER & CONSULTANT / EXPERT

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

  • 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åAndrée Starå ✭✭✭✭✭

    Happy to help!

    Best,

    Andrée

    SMARTSHEET PARTNER & CONSULTANT / EXPERT

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

  • Andrée Starå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

    

    SMARTSHEET PARTNER & CONSULTANT / EXPERT

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

Sign In or Register to comment.