TOTALFLOAT returns #INVALID VALUE

Options

Hi,

I'm trying to use the TOTALFLOAT function to find the slack in my schedule from the critical path. I have dependencies enabled. The formula is =TOTALFLOAT([Task Name]@row). Task Name is my primary column. However, it won't return a value, just the #INVALID VALUE error. I baselined my schedule already but it shouldn't have an effect. What am I doing wrong?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!