New entries to the Smartsheet don't include formulas

Hi all,

New entries into my Smartsheet are not including the 2 formulas I have created. I have tried the troubleshooting which advised the following:

Ensure the formulas are present in cells near where you want the new rows to appear.
Check if the last row before the new entry is indented, and remove any unnecessary indentation.

Neither of these apply. The formulas are present on all current entries and there is no indentation to remove. Any ideas what could be causing this?

Formulas are in T&L column and Total Time column.

Thanks so much!

Terri

Find more posts tagged with

Forms

Formulas

Accepted answers

Andrée Starå

https://community.smartsheet.com/discussion/142055/new-entries-to-the-smartsheet-dont-include-formulas

Hi,

I hope you're well and safe!

Strange!

If you haven’t already, I recommend submitting a support ticket through the new Smartsheet Support Portal.

I hope that helps!

Be safe, and have a fantastic day!

Best,

Andrée Starå | Smartsheet Expert Consultant & Partner / CEO @ WORK BOLD

✅ Did I help answer your question/solve the problem? Please support with💡 ⬆️ ❤️, and/or ✅ Answer. This will make it easier for others to find a solution or help answer. I appreciate it, thank you! 🙏

All comments

Andrée Starå

https://community.smartsheet.com/discussion/142055/new-entries-to-the-smartsheet-dont-include-formulas

Tjmarget

I will do that. It is happening to all three of my Boiler Plant logs. I am wondering if it is a Smartsheet issue.

Thanks as always, Andree!

Tjmarget

To close the loop on this incase someone else runs into this problem, somehow the formulas in my sheet got converted to cell formula. Once I got instruction on how to convert them back to column formulas (right click on the cell with the formula and select "Convert to column formula,") the new entries had the formula included. A quick fix!

Andrée Starå

Excellent!

Glad you got it working!

✅ Remember! Did I help answer your questions or solve the problem? Please support with💡 ⬆️ ❤️, and/or ✅ Answer. It will make it easier for others to find a solution or help answer. I appreciate it, thank you! 🙏

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.