How to write a formula that uses a dynamic row number (but not @row).

NJDevil

Hi,

I need to be able to dynamically reference a row number in a formula (not using @row).

Simple baseline example for our discussion:

= [Task Name]1 + "-" + [Task Name]2

Result: First Task-Second Task

But I need to dynamically provide the "1" and "2" row indicators.

I have tried the following without success:

* Use the + to concatenate

* Use & to concatenate

How can I get this to work, please? There must be a trick, no?

Thank you.

NJDevil

Additionally, there is no "Indirect" formula (like Excel has) in Smartsheet. Even so, I think I will still need to be able to somehow concatenate the dynamic value in the formula.

SteyJ

https://community.smartsheet.com/discussion/114113/how-to-write-a-formula-that-uses-a-dynamic-row-number-but-not-row

It might help to come at this from a different angle. For instance, how are the dynamic rows selected? There might be different solution rather than dynamically updating the column reference

NJDevil

Without getting into all that, is the functionality even supported? I doubt it, but need to confirm.

Thank you.