Pivot Sheet & formulas

Frankie_2018
Frankie_2018 ✭
edited 12/09/19 in Formulas and Functions

HI, I've used pivot sheet to gather required information to show up in a sheet. I've attached a clip of the final result which works great except for the fact that I have formulas in some cells. When a new row is created, the formulas in the cells from above don't copy into the new cells. 

Can someone help me out.

thanks!

PivotSheet.JPG

Tags:
· Share on FacebookShare on Twitter

Comments

  • Shaine Greenwood
    Shaine Greenwood Employee

    Hi Frankie—

    It appears from your screenshot that the formulas you're wanting to autofill exist in parent rows on your sheet. The autofill formulas capability in Smartsheet won't autofill a formula across parent rows. (This is by design.)

    In this case, you'll need to manually copy your formula down to the next parent row, once you create it.

    Let me know if you were wanting rows to autofill on different rows and I'll be happy to help with a screenshot of those rows and an example of your function.

    · Share on FacebookShare on Twitter
  • haznedarj
    haznedarj ✭✭✭

    Hi I have the same issue. Can you share how I can get rows updated automatically with the formula above when new data gets added and synced within the pivot sheet? Thx. 

    · Share on FacebookShare on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!