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

Automated email with number of pending records
Hello, I use Smartsheet in such way that people are asked to provide data on many records and then that data needs to be approved by one other person (always the same person). I would like to set up an automation that, each morning, checks to see if there are records waiting to be approved, and if there are, sends an…
How to Share Single Workspace Folder?
I have a workspace that I created with two subfolders. A user needs to have access to only one of them but when I have that folder selected, I can only share the entire workspace with them. Is there a secret way that I can share the parent folder and ensure that any new files created will be shared with the same people? I…
License Question
I already have a Smartsheet license with my company, but I was recently invited to collaborate on a sheet owned by another group within the same organization. When I accepted, I was told I need to upgrade in order to edit or contribute. Can you please explain why this is required? It seems unreasonable to need multiple…