Reference a sheet summary field and use as a column formula


I want to assign the same project number to every row in my sheet. I want to have a "Project ID" summary field. And then have a column formula in my sheet: =[Project ID]#

It works as expected (returning the Project ID) for any row I physically type that formula in. When I convert to column formula, it does not return any value, just blank.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!