Is it possible to Sum based off of status change in a different column?

For instance,

if I had two columns, one is a number value and the other is a status value. if the status value is red and i wanted to sum just the values of the red statuses, is this possible by using a SUMIF Function.





Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!