Specific cell reference in update request text

Marie PH
Marie PH ✭✭
in Formulas and Functions

Hello!

My examples are in French, but as SS is the same, you should understand with the visuals.


I used a template as a base for my project management office.

In this example, we create a folder with the project name, but all the subfolders remain β€œgeneric” in order for the links between them to continue working if we make a folder copy.

https://www.smartsheet.com/marketplace/us/template-sets/project-schedule-management
image.png

(We do not have the control center, so it seemed a great way to work to multiply projects with all their reports and dashboards).


So I have my sheet called β€œProject plan”, a column β€œTask name” and on this same column, row 1, being the project title β€œIT risk assessment”


titre.PNG


Lower on the sheet, I have the activity breakdown with different people assigned.

tasks.PNG


My goal is to be able to reference the project title when I create a workflow with any request type.

request.PNG


1) It seems I cannot reference a specific cell

2)I tried putting the project name in the sheet summary, but once again, it seems I cannot reference the sheet summary

Summary.PNG


3) I tried to create a helper column in which I could point to the project name, to have it for each activity. But since my formula points toward a specific cell, I cannot convert it to column formula (and I don't want to copy it manually).

helper.PNG


Please proove me wrong on those points or let me know should you have another way to achieve this goal!

Thanks for your help!

Tags:
· Share on FacebookShare on Twitter

Best Answers

Answers

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!