Formula Auto populate

Hi,

I am facing a challenge..when I submit a new form the formula is not auto populated in that row..Please advice.

moreever, I am using a IF error formula this does not show blank like its does in Excel

IFERROR(IF(VLOOKUP([ES_Code]1, {Lookup Sheet Range 1}, 7, 0) = [Audit fees are denominated in this currency]1, "Yes", "No"), "")

Find more posts tagged with

Forms

Comments

Andrée Starå

Hi,

It should work but there are some things to consider.

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.

Please see the attached link/screenshot for more information.

https://help.smartsheet.com/articles/1641473-auto-filling-formulas-and-formatting

I hope this helps you!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

TiboP

Hi,

it's seems in my case that I need to save the sheet (Ctrl+S) after inserting a new row that populate formulas correctly to be able to insert again a new row that populate formulas.

If I don't save (Ctrl+S) in between adding new row the formulas don't populate.

Do you get the same behaviour ?

Best Regards

Thibaud

Andrée Starå

Hi Thibaud,

Are you inserting empty rows and are you adding something to them before you insert/create the next one?

Best,

Andrée

Sign in to join the conversation!

Quick Links

Trending discussions

Monthly feedback from multiple individuals
Hello community, I need help figuring out how to set up a sheet to collect monthly comments on several projects. Each project is assigned to a different person who need to provide monthly feedback on its progress. Ideally, I would like them to receive a reminder notification on the report due date, followed by reminders if…
Sheet shows BLANK rows, there is a "MOVE rows" worflow, is that why?
Is it possible that a workflow that MOVES rows to another sheet too basically do a CUT/PASTE (like in Excel), and then you are left with BLANK rows on your original sheet? I cannot think of any other LOGICAL reason why this would happen. The users enter the data from an Intake Form, it gets placed onto this sheet. They do…
Sorting not working?
Hi. I have a sheet where I am sorting dates by ascending order. But the sorting functionality doesn't seem to be working. Instead of bringing all items with date values to the top of the sheeting and sorting them in ascending order, it leaves a gap. Is it a result of the "Next Review Due" column containing a column formula…