Add new row, calculated field not updating

I have a sheet that uses Hierarchy (on month) and is displayed in descending sort order. I have one calculated field that should be automatically calculated when a new row is added.

When the person who will be entering data adds a new row, they are using "Insert Above" to add the row. The calculated field is not updated.

How can I force the calculation to happen automatically?

Thanks,

Pam

Find more posts tagged with

Formulas

functionality

Accepted answers

Pamb10

Thanks sooo much for all who took a stab at this one....

I had an epiphany over the weekend, so I gave this one thing a try.

I copied the formula to the top row, ie. where the month name is. It was like this for the # Days column, so i did the same for Monthnumber. That seemed to perform the magic I needed.

Thanks again to all.

Pam

All comments

Andrée Starå

Hi Pam,

Can you maybe share some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)

I hope that helps!

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Paul Newcome

Where is your calculated field, and what is the exact formula you are using?

Pamb10

Here is a screenshot. Hope this helps.

Paul Newcome

If there is no data in the [Date Credentialed] column, then no calculation will occur. That's how the formula is written.

Pamb10

Sorry, I guess that was a poor representation. If i enter something into Date Credentialed, nothing calculates.

I think this has something to do with the "Insert above" way we need to add the row, the formula is not copied to that cell when row is added.

Paul Newcome

When the row is added... What hierarchy level is it? Do you end up having to indent to make it a child row after adding it?

Pamb10

No. Since there are other child rows, this was already indented when added.

Paul Newcome

It should be auto-filling the formula then. As long as there are at least two rows above and/or below the new row with the same hierarchy containing the formula, then it should pull. I just tested inserting a new child row immediately beneath the parent row, and it worked for me.

Are you able to "Save as new" then delete all of the data except for the dates and formula column then share a published (edit by anyone) link here? That way I could get into the sheet and take a look without having access to the sensitive data you have blurred out, and any changes won't affect your actual sheet that's in production.

Pamb10

Ok, thanks. Never shared like this before. Still kinda new to SS. Hope this link works.

URL: https://app.smartsheet.com/b/publish?EQBCT=b5d5c0a10e314c2596f7145c8f79190c

To give my exact steps....On the sheet, right click on the top green row and select Insert Above. Enter a Credentialed Date.

In your message above, you said you tested Insert Below.....I am doing Insert Above....

Andrée Starå

@Pamb10 I tested and it works if you select insert below. Not sure why it doesn't work when using insert above.

If you haven’t already, I would recommend that you reach out to the Smartsheet Support Team.

Let us know what you find out!

Paul Newcome

My apologies. I used the wrong verbiage when describing what I did. It was a new row below the parent row, but I used "Insert above" after clicking on the top child row to put it there.

Paul Newcome

When I tested on your sheet, it did pull the number of days column on your formula. I'm not sure why it didn't pull the other formula. I second Andree's suggestion of reaching out to support. I don't know why it wold work for one column and not the other.

Pamb10

Thanks sooo much for all who took a stab at this one....

I had an epiphany over the weekend, so I gave this one thing a try.

I copied the formula to the top row, ie. where the month name is. It was like this for the # Days column, so i did the same for Monthnumber. That seemed to perform the magic I needed.

Thanks again to all.

Pam

Paul Newcome

Glad you were able to get it working!!

Don't forget to flag your comment as "helpful". That way it will be tagged as the "Best Answer" and let others encountering a similar problem know that a possible solution may be found here.

Andrée Starå

@Pamb10

You're more than welcome!

Glad you got it working!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.