Using cells in a reference for a metric sheet
I am quite new to smartsheet and had a questions about some widgets.
When referring to another sheet in my calculations sheet, I want to refer to a set of cells in a column instead of the entire column. However, I want it to update based on new info entered in the column. Also, anytime the sheet is sorted, it makes my CountIF formula inaccurate. How can I fix this?