Trying to get a column to populate the same value for every row.

Dave from JBM

I am attempting to get a single cell value from [BaselineLookup] to populate into every row in [Baseline].

I have tried a couple formulas but so far I keep getting a message that says the formula isn't quite right when I try to convert it to a column user.

Thanks in advance!

Darren Mullen

@Dave from JBM add a "#" being the summary field name

[Water Baseline]#

I have that hint in my tips document, you might benefit from some of the other tips it has.

Https://smartsheetguru.com/tips

Darren Mullen

@Dave from JBM yes column formula can't reference a cell. You'll need to use a sheet summary field for the value then use the sheet summary in the column formula.

Andrée Starå

Hi @Dave from JBM

I hope you're well and safe!

You'd need to use the Sheet Summary fields or an INDEX formula.

Would any of those options work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Dave from JBM

@Andrée Starå @Darren Mullen thanks for the info guys. I have no experience with the sheet summary field so I will do some research on that.

Dave from JBM

@Andrée Starå @Darren Mullen I was able to get the reference in the sheet where this value is updated but I cannot figure out how to get that into the sheet where I need all the values to update.. I tried the formula highlighted in yellow in both sheets both return #unparseable.

The summary field will update if I change that value in the sheet though so I think I made some progress.

Darren Mullen

@Dave from JBM add a "#" being the summary field name

[Water Baseline]#

I have that hint in my tips document, you might benefit from some of the other tips it has.

Https://smartsheetguru.com/tips