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!