-
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…
-
Alert based on row deletion
Hello All, Is there a way to setup an alert that has the following conditions: IF row on 'X' sheet is deleted by anyone but 'Y', sent alert to 'Z'. I thought about creating and alert that said if row is deleted alert 'Z' if 'modified by' is not 'Y'. It doesn't look like I can do this though as the work-flow parameters I…
-
V-axis showing 0 and 1 instead of %
In my chart, I am displaying %, and the chart is showing that in Series -> Data Labels, but the vertical axis is showing only "0" and "1". I would like the vertical axis to show the values given, those between 0 and 1, as a %. Your help is appreciated. Thank you.
-
How to PDF print multiple months in the Calendar APP?
Self explanatory hopefully from the title. I wanted to PDF print a full calendar year from the PDF print function in the calendar app. Unsure of how to do this as PDF print function only brings me to the view of current month in the App Thanks
