Formula to count number of task

edited 12/09/19 in Formulas and Functions


I need help with adding a formulat to count the number of task.  I tried adding the formula but it didn't count the task it adds it to the number of task for the above row.  I'm fairly new to smartsheet so it's taking me a minute to figure out the formulas. Any help will be great appreciated. 

This is the formula I used.

="# of Grants May - " + COUNT(CHILDREN())

Thank you



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!