Help with #REF

AClark200

All was good until... Everything was working as designed while setting up PMO template set. Not sure what I did but getting #REF error and would appreciate help in correcting the error . Thank you in advance for your help!

Ryan Sides

Option1:

Click the right side panel icon for "Summary". Do you have a field in there called Project Name or similar?

I think the first Task Name references that field in the Summary. Once you figure out the name (or if it doesn't exist, click the "New Field button in the Summary), come back to the first row and in the Task Name column add

=[Project Name]# Replace "Project Name" in this formula with whatever your actual field name is.

Option2:

Alternatively, you can type over what's in that Task Name column with your actual project name and not worry about the Summary field.

Ryan Sides

Hey! This is usually b/c you deleted the column/cell that the cell was pointing to originally. Did that happen? What is the formula in that cell? What should it be displaying?

AClark200

Hi Ryan,

The problem is that I do not know which column/cell was deleted. I am new to Smartsheets and not sure what formula is needed and how to place/map it in the "field"

Appreciate the guidance.

AClark200

Ryan Sides

Option1:

Click the right side panel icon for "Summary". Do you have a field in there called Project Name or similar?

I think the first Task Name references that field in the Summary. Once you figure out the name (or if it doesn't exist, click the "New Field button in the Summary), come back to the first row and in the Task Name column add

=[Project Name]# Replace "Project Name" in this formula with whatever your actual field name is.

Option2:

Alternatively, you can type over what's in that Task Name column with your actual project name and not worry about the Summary field.

AClark200

AClark200

Thank you Ryan appreciate the help!

Ryan Sides

You're welcome! Hope that helped.