Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Autofill formulas from adding a new Card

edited 12/09/19 in Archived 2017 Posts

I find the value of Smartsheets to be the card view. I almost exclusively work in card view, and routinely add new items by adding new cards. There are several fields that contain formulas. Until today, adding a new card seemed to add the row appropriately at the bottom of the sheet, inheriting formulas. However, i'm finding it doesn't always do that. One card I added was inserted something like 10 rows below the lowest row in the sheet, and therefore does not inherit the formulas. How do I force it to add a new card to the next available row, therefore including all forumlas?


  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭

    This is usually caused by something telling the Sheet that the 10 blank lines are 'active' (I don't think that is the right word, but the correct one escapes me at the moment). 

    Check to see if any of the blank rows have a Creation date (added the System column if you don't already have one).

    If they do not, contact support@smartsheet.com and be ready to share your sheet with them. I usually provide the editable Publish link to save time.

    There is something going on (a bug), but I have not been able to find the pattern by my own testing.


This discussion has been closed.