Hyperlink cell value connecting to a specific sheet row

There is no way to link directly to a specific row, but you can add a column to include the row number on each sheet, then pull a report.

The report will have a column that has a link to the sheet, and if you include the row number column from them, then the user will know exactly where to look after clicking on the sheet link.

I'm always happy to help!

The best option is to try to find something else that we could use to identify the parents if it's not an alternative to add a column (even if we hide it?).

What do you think?

All comments

Is each project a different sheet?

Yes, Paul.

There is no way to link directly to a specific row, but you can add a column to include the row number on each sheet, then pull a report.

The report will have a column that has a link to the sheet, and if you include the row number column from them, then the user will know exactly where to look after clicking on the sheet link.

Thanks, Paul. I am going to try this approach to see if this helps. Thanks a lot for quick help.

Kind Regards,

Chitta

Happy to help. 👍️

An option for quickly jumping to a row once you have opened the sheet is to press CTRL+G and then type in the row number and either hit "Enter" or click on "OK". That will help avoid a lot of scrolling.

Thank you, Paul 👍️

Hi Paul,

Does the newer version of Smartsheet report filter can accommodate formulas?

I am finding difficulty on how to add formulas while I am building the report. Report filter only shows column names, condition and criteria but I want to use formula while fetching the data.

Here is the screenshot I am referring:

I want to retrieve parent child rows from my sheet but above condition will give only retrieve children rows but but not parent. I may be missing something here.

Can you please suggest how to achieve this.

Kind Regards,

Chitta

Hi @Chitta

I hope you're well and safe!

You can't use formulas in reports, but you can use the Grouping and Summarize features to create something similar.

Would that 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 help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Show both parent and child rows in report, even if the Parent doesn't meet the criteria — Smartsheet Community

Hi Andree,

Thanks for letting me know that formulas don't work with reports. I was reading another thread using Parent, Children row retrieval and mention of formula and I was wondering if there was any option in older version which may have moved to different feature I may not know in newer version.

Considering Summarize and Grouping feature do you think my requirement can be achieved?

I am reposting my earlier requirement shared in this post: Is it possible to retrieve parent child rows in my report? I am filtering based on taskname = Training or Communication, I want to retrieve parent of applied conditional row.

Or do you suggest any other approach?

Kind Regards,

Chitta

Happy to help!

Yes, you could so-called helper columns that indicate if it's a parent, the parent's name, and then we'd use that together with the grouping feature.

Another option that I often use in my client solution is to add a so-called helper column showing the parent name or hierarchy on each row to see it but don't necessarily need to use the grouping feature.

What do you think?

Hi Andree,

Helper column is a default column in sheet? if not, adding a column project template is not an option as project templates are used by at least 12 projects so adding another column in project template requires approval from teams and most likely to get rejected.

Wondering if there any other way of achieving this requirement without disturbing project sheet.

I really appreciate the solutions you and Paul is sharing, I am learning a lot!

Kind Regards,

Chitta

I'm always happy to help!

The best option is to try to find something else that we could use to identify the parents if it's not an alternative to add a column (even if we hide it?).

What do you think?

Thank you, Andree :-)