Parent row possibility?


I have an idea but I'm not sure it's possible, need some advice.

I have a form I've created with an option to add 5 submissions. I need to be able to total these submissions based on who filled out the form. Right now I have a helper column that adds the submissions up that are on the row, but I wondered if I couldn't set it up to where each new submission falls on it's own row but under the same submitter name? I will attach a photo of how it's set up now for reference. I also looked at a formula to total these amounts based on the submitter but I can't make that work either.

Any ideas?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!