-
What exactly trigger different alerts? The labels stink!
Alert 1: If you select Create a new rule and Alert Someone you receive a pop-up that has a top line of 'Trigger: When a row is added or changed" and the next line is When Any field changes If I press Save I see the alert with a description of 'When a row is added or changed' but nothing about any field being changed. When…
-
Ideas on transition between annual project tracker sheets
Hello, I am looking for a way to "connect" two Smartsheets that track a variety of projects (one for 2019, one for 2020). Curious to see if anyone has done this, recognizing that some work may extend into the next year, and if there are any lessons learned / pro-tips in creating and maintaining such a concept. Thanks for…
-
Create Group Contacts
Hello - I am a PM for a large org and need to request updates. How do I create groups? Sometimes I have 40 plus team members. My question is - I am not a group admin - Can I create groups to help streamline my updating process? Thanks in advance!
-
Batch rename sheets in a copied workspace
I'm hoping someone might be able to assist. I copied a workspace for an event we are hosting. As you can imagine there are a lot of sheets with the name of the event in the title. Is there a way to mass replace the sheet title where the name of event appears (LEB) to the name of the new event (LT)?
-
Workspaces do not appear on "link to" file list
In taking the eAcademy course, in the Cell Linking chapter, I am told to link to a file in the eAcademy workspace. When I try to do that, I notice that I have no access to any workspaces from the link to functionality. I can get my learning about this concept from the class. My concern is, moving forward, will I not have…
-
Simple team-member tracking calendar
Members of our department are allowed to work remotely two days each week. We want to set up a calendar where we can show which days each of us will be out of the office. In most cases, each of us will have the same two days each week, but we can change if needed. I created a new document and went into the Calendar view,…
-
Sheet Reminders not working
Good afternoon, I use the Row Reminders religiously and since last week this function has been hit or miss. I created several row reminders for various sheets on June 11th to come to my Outlook inbox June 14th. All reminders created are still sitting in Smartsheet. I've voiced this issue to support earlier this week and…
-
SmartSheet backup including formulas
Hi, I can't seem to find the answer anywhere on the forum. Pardon me if this has been addressed. Is there a way to backup SmartSheet plans and preserve the formula? I've created a bunch of formula for all project plans and it would be impossible for me to remember every formula should I need to restore it from backup. So…
-
Email feedback to web form submitter
Hi, I have a Smartsheet set up on a project with a smartsheet web form in it. One of the fields that is not mandatory for the form user to fill is their email address. I was wondering, is it at all possible to automate personal feedback to all those who include their email address when filling the form? The personal…
-
Vlookup limitation of 25000 cells
Can anyone help me to rectify the error as I am using cross sheet vlookup function in Smartsheet to extract some information, while doing this I am facing the error that we can only reference a total of 25000 cells. Is there any way If we want to update multiple columns with the help of other sheet just to avoid the manual…
