I am using the send update request automation. However, it does not show the sheet name. Besides renaming the email subject, is there a way to add this? I noticed my automated reminders automatically include the sheet name. (see below).
I hope you're well and safe!
You could add a so-called helper column and a formula showing the sheet name and then convert it to a column formula, so it's included on all rows and in the update request.
Would that work/help?
I hope that helps!
Be safe, and have a fantastic week!
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!
SMARTSHEET EXPERT CONSULTANT & PARTNER
W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Thanks, I was able to make it work for 1 cell but when trying to apply it as a column formula, the column formulas would error out. "The column formula syntax isn't quite right, see our help article."
NOTE: Column formulas cannot refer to cells or ranges with specific row numbers such as with absolute references, specific cell references, or partial-column ranges. Use @row, column references, and cross sheet references instead.
When trying to use the example =[Task]:[Task] I keep getting an unparseable error.
Happy to help!
Try something like this. (Change the name to reflect your sheet name)
You could also add a field in the Sheet Summary and reference it in the formula instead. This is especially useful when you have a template you reuse.
Did it work?
✅Remember! 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!
Thanks, it did help. The only limitation is that free users can't change the sheet name since it's a formula. I am creating a template. Any workaround for this?
You're more than welcome!
You could add the name to a sheet summary field and reference it in the column instead.
Hi. Does saving a sheet after hiding columns delete the hidden columns or will they still be there?
Can someone help me please? In the “Queue” column, I have “mapped” from “ComponentID” column a list of values (using IF function), but now I must add to the existent formula the new value “ArtStation.” This comes from a long list of alphanumeric codes. All those codes start with “asset”, the problem is that I get…
Hello - is it possible to use a group already established in SmartSheet to fill/populate a drop list for a data point? Example - we have a SS group created for 40 project managers, I would like to type the name of the group in the drop down and the 40 names populate in the drop down list without having to type all 40 names…
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2024. All Rights Reserved Smartsheet Inc.