Archived 2017 Posts

Archived 2017 Posts

Welcome to the Smartsheet Forum Archives


The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Maintaining Formulas When Sorting a Sheet

✭✭✭
edited 12/09/19 in Archived 2017 Posts

Hi, 

Is there a way to sort a sheet where the formulas do not change. I have a few formulas at the top of a sheet and whenever someone sorts through the sheet, my formulas change based on where it was moved to. 

 

My formula is a COUNTIFS and I want it to count what I am asking regardless of where in the sheet the row where the formula is jumps to. Is this possible? I have a lot of people that look at the sheet and like to filter, only it mixes the formula.

Comments

This discussion has been closed.

Trending Posts