Help with formula


I need some help with a formula.

See sheet summary.

I just need help with the first one "move in items open" and I can apply the same formula structure to the rest.

I want to count the amount of Warranty phase column if that says "move in items" and the status is Not started or In progress" and have that be 1 number.

Any help would be greatly appreciated.


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!