Feature Request: Static formula's for a column

Kelly Ospina

Adding my vote for an embedded formula column as well. This is our number-one support request issue, and it sucks up huge amounts of time and manpower. 

Smartsheet adds ten extra rows at the bottom of every sheet, which also causes issues. 

Being able to select an embedded formula column as a column type when creating the sheet seems like the only true fix.

Colin Entrekin

I was having the same issue.  A workaround that I discovered was adding new rows to the top of the sheet, rather than the bottom.  Problem solved.  Auto-fill always works now.



If you can have new rows come in this way, as opposed to at the bottom of the sheet, this should be a fix.

Colin Entrekin

Workaround is make new rows come in at the top of the sheet, rather than the bottom.  

Andrée Starå

Hi Colin,

Most of my clients prefer getting the submissions in the sheet's top instead. I usually create two rows in the top and then hide them with a Default filter.

Hope that helps!

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

David Bright

Thanks Colin and Andree,

This may help for certain cases, but in my case my users don't only submit new rows using forms. Most of the time they work directly in the sheet, and they typically have 100's of rows, and they group them and arrange them using Expand/Collapse etc. Typically inserting new rows anywhere in the sheet.

Using the techniques you describe in those cases, doesn't help.

So instead I have to setup "health check" reports that run every day to let me know when formulas are "broken" and then I have to go into the sheets and manually fix the broken formulas.

This is the reason for the enhancement request - if Smartsheet had a Column Type of "fixed formula", then we could define the formula at the "column" level and it would always apply to all cells in that column.

Thanks,

David

 

Andrée Starå

Happy to help!

That would be a great enhancement!

Best,

Andrée

fraygosa

Still an issue, please add a formula column apply method please.

Andrée Starå

Hi everyone,

Please submit an Enhancement Request when you have a moment to have your vote added

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

lmarchisio

David,

I have a similar issue.  Monitoring multiple sheets with multiple users because it is impossible to get everyone to remember to input data consistently, with no blank lines.  There is a possible solution using the API and Google Cloud to find blank cells and overwrite them.  I have only tested it on a few sheets, and there is plenty of cleanup that can be done.  But it works well so far.    

Feel free to reach out if you need more information.  

https://github.com/lmarchisio/smartsheet-python_webhook

Best,

Lisa

David Bright

Thanks Lisa.

I have implemented a number of "health check" processes across all my sheets to detect and fix a bunch of these types of errors and that is working okay for now. I am investigating automation using the APIs as well.

Regards,

David