Auto-fill is outdated

The conditions that formula auto-fill performs in are ridiculous (based on the row above/below). It's incredibly temperamental and not fit for purpose.

Likewise if you copy a formula down a column, I'm experience the following problems:

When you add a new entry into the card view, it adds the result to the end of where you copied the formula to in grid view.
When you go into card view, the cards are all assigned as uncatergorised.

Please can you update this archaic system so that these functions stop doing this.

Find more posts tagged with

Formulas

Marketing

Comments

Andrée Starå

Hi Gary,

Please submit an Enhancement Request when you have a moment.

A New Way to Submit Your Feature Requests

To make your Enhancement / Feature Request count, send in the form above because there isn’t a guarantee, it will be registered otherwise.

Original Post: https://community.smartsheet.com/announcement/new-way-submit-your-feature-requests

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Alejandra

Hello,

In card view, a lane is equivalent to a value in a dropdown, contact, or symbol column in Grid View. Cards in the uncategorized lane appear there because the row doesn't have a value in the column you're viewing by.

Also, if you've dragged a formula down a couple of rows while in grid view, any new card that is added in card view will be displayed below the rows containing the formula because although the rows appear blank, they've been modified.

Formula autofill also applies to new rows created in card view, but I understand this does fit your use case. When you have a moment, please let our Product team know about any feedback you have by submitting a Product Enhancement Request.

Sign in to join the conversation!

Quick Links

Trending discussions

Countif, index/match
I'm working on a formula that will return a count based on a matching dates and the word "Quality", but I'm getting the unparseable error. I'm sure it has to do with where I'm putting the ) and ,0 ,1. Here are some that I have tried:
Help creating formula to return a date in a column that is closest to today's date
I need help creating a formula that references the "Due in Payroll" column I have which is a series of dates. I would like the formula to look at that date column, and return whichever date in that column is closest to today's date. I've tried several formulas, all come up invalid column type, unparseable invalid…
Formula to Convert Scientific Notation to Numerical Value
Hi, I am trying to create a sheet from data that is originally held in .csv files. My goal is to make it so that transferring the data to my sheet should be as simple as just copy and paste. My issue is that two of the fields that I need to copy over are reported in scientific notation (1.3E+004) and I am trying to figure…