Referencing Content within a Cell


Hi there!

I'm creating a set of formulas that will reference a sign up form. Since there is a lot of Wordy items to copy, I have created a reference column on my metrics page- is there a way to use my count if formula to reference the content in my Metric Reference Column to the column of the Sign Up Form?

I've been trying to use =countifs(Sign up Column 1, $Metric Reference Cell etc.) but can't seem to get it to work- what am I doing wrong?


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!