Welcome!

Auto Fill Formulas

I have a couple of formulas that need to be generated on each new row entry.

Also I have an automated Create(Date) column.

If the rows are deleted that do not contain the formulas in at least the last two empty rows, then the formula disappears.

But if I add the formulas to the last two empty rows, then the Create(Date) column is populated.

Is there a work around for this?

Find more posts tagged with

Comments

Andrée Starå

Hi,

Not sure I follow!

The Created (Date) column is a system column, so it's automatic.

What do you want to happen? How would you like to use it?

Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

P.Bushong

Thanks for your response. It is working good now today. Not sure what happened. Basically I have a formula that needs to be repeated on each new record.

Example: A new column was created after rows 1-10 was previously filled. The column data type is a check box with a formula to check the box depending on a certain condition.

On the next new record created the the new formula was not appearing, so i had to copy the formula to the next two empty records in order for the formula to appear on any future records within this sheet. I have a date created column and this auto updated with the check box appearing.

Any ways long story short it is no longer an issue.

Andrée Starå

Excellent!

Happy to help!

Troy S.

Formulas will autofill when they are in the rows either two-rows above or two rows below the new row, at the same level of hierarchy. It's possible your formulas weren't carrying down due to a parent/child relationship breaking the autofill.

Best,

Troy

P.Bushong

I do not have a hierarchy with parent/child relationship. so no sure.

Sign in to join the conversation!

Quick Links

Trending discussions

Using single-sign-on with external partners
We want to implement single-sign-on at work and have received approval. However, our IT department wants all external partners to have/use Mayo credentials to log into Smartsheet. Not all of our external partners ever set foot on our campus and don't have our company credentials. I have a couple of questions. Has any other…
Cannot create new Chart from a report
I can create a Chart in Dashboard from sheet well but from Report is not working now. I just try with simple Report (just contain 2 column Primary and Number) but cannot make the chart. Is there any changes recently right, because I haven't worked with Smartsheet dashboard for a long time and I remembered that I could do…
Anyone have the link to register for the Core Product Exam without the Learning Pass.
Cant find this anywhere