New Row Formula Issues/ Default New Row Feature?
I'm looking to take a Smartsheet I created for my department and to share it with other teams. It's fairly simple, but I have a few formulas doing some stuff:
 A Status Ball that syncs with the status text.
 A formula in a PARENT_PROJECT =(PARENT([Project]@row)) that syncs with the Parent Project name so that I can use the Projects as lanes in Card View (since Card View works only with Dropdowns). This field is hidden in Grid View since it is redundant.
Here is my problem:
 Adding a new line at the bottom of my sheet copies the Status Ball formula, but not the PARENT_PROJECT formula.
 There doesn't appear to be a way to inject any formulas on rows added by a Form.
If I am going to be using this as a application across my org, I need a consistent way to get preformatted data into the hands of my other managers. Is there any solve for both or either of the problems I am running into? Is there a "default row" option?
Thanks in advance!
Comments

When you use a form you are adding a row to the sheet. If you are adding the row to the bottom of the sheet, smartsheet will find the lowest row and check if there are any formulas in it. If there are any formulas, it will copy them and paste them in the new row.
As a general rule, you want to avoid sharing sheets in smartsheet as much as possible. Instead you can share dashboards with the information applicable to each user sorted out and filtered in a meaningful manner. Of course there are obviously exceptions to this, but one of the main advantages of the form is that it allows users to give you information without having access to the sheets.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.9K Get Help
 410 Global Discussions
 219 Industry Talk
 457 Announcements
 4.8K Ideas & Feature Requests
 143 Brandfolder
 136 Just for fun
 57 Community Job Board
 459 Show & Tell
 31 Member Spotlight
 1 SmartStories
 298 Events
 37 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!