Formula not auto-populating

I have several sheets that are identical. I actually created the additional sheets by using Save as New.

In all sheets when I enter an open date, follow up dates are supposed to auto-populate based on a formula (example =[Open date]12 + 2). In some sheets it is working fine, in others sheets, it is not. What could be different?

Find more posts tagged with

Comments

Tim Meeks

Verify that your column properties are identical in each sheet. If it's not too much work, I'd create new sheets from the ones where the auto-populate is working and then copy the data from the sheets where it is not working and delete these sheets.

J. Craig Williams

I'd also suggest reporting to support@smartsheet.com if you can share the sheet(s). This is a long standing annoyance and maybe someone example will be what they need to fix it.

Craig

Sign in to join the conversation!

Quick Links

Trending discussions

If you switch your Grid View to Table view, can and will your sheet stay as a table view permanently
I ask this question because i have switched my grid sheets before to table view and exited out of the sheet, then when i come back its back in grid view. Just wondering if thats normal. thanks
Request for Update Report (or something like it)
Hi there! I'm hoping this group can help. I'm building out program/project management & tracking at my company. We have 8 grids (one for each dept) that funnel into multiple reports and dashboards. Within each grid/sheet, there are multiple projects that have CHILDREN project plans nested underneath. We want project owners…
Column with a restricted list very difficult to edit
Hello, I have a column with a restricted list of 100 entries. When I edit the list and scroll to the 50th entry, as soon as I type to change the entry name the column scrolls to the top and I cannot see what I am typing or deleting. I have to keep scrolling back down to the row to see what I have keyed in. Very annoying…