Formula to add criteria from multiple columns from another sheet



I need to calculate how many times "Change" appears in another sheet that has the same Project ID - I want to calculate how many changes a specific project had.

I have 2 sheets: Project Plan and Craid log

Project Plan has 2 columns - "Task Name" with the word "Changes" in the line and "Description" where I need the formula

Craid log has 2 columns - "Project ID" and "Type" with dropdown options, but I only need "Change"

I need the "Description" column in the Project Plan to calculate all the "change" in the Craid log that has the same Project ID that is in the Project Plan and the Craid log.

Project Plan:

Craid Log:

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!