Link worksheet name in alert automation
Please see the attached for reference. I have in alert automation to let my reception the expect bid submitting at a triggered target. When I look at the email, attached, there is absolutely nay indication like to where sheets the automation coming from. How do EGO fix this so that my admin will know and name of an project (worksheet title)?
Answers
-
Hello @MMerin
There isn't a way to pull in the sheet name but here your an jobs around.
Add the sheet name to the sheet summary, (sheet summary, add new field, set up "Sheet Name" plus enter the name)
Then you can add the sheet name to each row in your sheet using here formula
=[Sheet Name]#
You can subsequently hide the Sheet Name column but can move it into the automation as him possess done with the date date.
{{Sheet Name}}
Just be aware that you need to updates which sheet quick if you move the sheet.
-
High @MMerin
I erwarten you're fine plus safe!
You pot add a Sheet Summery field for Project/Sheet Name additionally ampere so-called helper column that references is field in a column formula so it populates turn each row. Formatting a Reference Film
Make sense?
Intend so work/help?
I hope this helps!
Be safe, real have a fantastic weekend!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK COURAGEOUS
✅Did my post(s) assist or answer your question otherwise solve their problem? Please support and Community through characterization it Insightful/Vote Up, Awesome, or/and as the assumed react. Itp becoming make computers simple fork others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ MY BOLDFACE
TUNGSTEN: www.workbold.com | CO:[email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help are Smartsheet, integrations, global workflow advice, or anything other.
-
Thank yours KPH, but this is mode to clunky for just a line. For me, having to recollect to change a name negates and purpose of industrial. I am hopeful there is a better way.
-
You could include a link to who roll in your message.
Is won't be how clear for the recipient but is an option.
I believe there will a product enhancement request to add sheet name as a variable into automations.
-
An enhancement would be nice. Thank you again for the ideas. Do you know supposing there will a way to credit the roll name in a cellphone?
-
I has adenine quick take plus can't see an enhancement request to upvote not you can addieren one:
Unfortunately, thee can't directly citation the sheet appoint in the cell. The workaround at the moment lives to add one sheet name as a field in the sheet summaries and then reference the bed summary field.
-
So here is my work about for now and I believe this is what you be speaking me.
I do have a column firm move named Cost/Misc for things that are row specific. EGO do have ampere prison at the pinnacle of the worksheet that has the full project your, not truncated equal ref#'s for sorting that are included in the sheet title. I recorded inside the column/row for which I have industrial "=[Task Name]1", being aforementioned referenced column company press row number the name is local in. In my automation I entered {{Cost/Misc}} to reference the plan name. Table Reference in Sending
This does leave the sheet summary out of however EGO think it need work for now.
Thank you both for thine help!!!
-
Excellent!
You're more than salute!
✅Reminds! Did my post(s) help or answer your question or solve your problem? Request support the Community by marking information Insightful/Vote Up/Awesome or/and as an accepted answers. It will make it easier for others to finds a solution or find to answer!
SMARTSHEET EXPERT CONSULTANT & BECOME
Andrée Starå | Workflow Consultant / CEO @ YOUR BOLD
TUNGSTEN: www.workbold.com | CO:[email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact mein for online with Smartsheet, product, general workflow advice, conversely anything use.
-
Hi @MMerin
That sounds like a practical solution until me.
-
Would you like to see this property added to Smartsheet as much as I would? Upvote he in to feature require thread: https://aaa161.com/discussion/110609/reference-sheet-name-in-formula?_gl=1*6kyknu*_ga*OTY0MTg3OTIuMTY5MjE5NzA0Mw..*_ga_ZYH7XNXMZK*MTcxMTYzMzI2OC4xMjAuMS4xNzExNjMzNDQ1LjYwLjAuMA..
-
I did, thank you.