-
Unable to remove Smartsheets workspace
Hello! A year or two ago I added a workspace for the Smartsheet Mobilizer Kit v2 - a prepackage workspace that came directly from Smartsheets. I cannot delete it and I'm not sure where to ask for assistance. Can you direct me to the right group or help get me off of this workspace? Thank you, Emily
-
Symbol magically appears in a cell that is copied over to another sheet
I have a simple workflow that copies a row to another sheet. One cell is called a Job # and is populated with a number. When it copies over, the copied version has a symbol in front of the number. Example: '8282. I checked the original cell and no such symbol was accidently put in. Does anybody know what this is and what I…
-
Cell Linking
I have a inventory workspace. I am trying to set it up to link a cell on sheet a to a row on sheet b. The purpose is to set it up so that whenever the quantity on sheet A changes (no matter the cell), the quantity adjust on sheet B (for the entire row). Is this possible?
-
Tracking a 1-day project based on time not date
I am helping manage a 1-day Disaster Recovery exercise and we want to track the tasks by start & end based on time of day. Would also like to auto adjust the times with dependencies - Does anyone know if a template is available of has anyone ever done this before?
-
Automation emails not sending consistently to some contacts
I'm running into a strange issue with automations and email delivery, and I'm hoping someone can clarify how to fix this. Setup: I have a Smartsheet form with: A required “Your Email” field (Contact column) Several hidden Contact List fields populated automatically Automations use “Send to contacts in a cell” Submitted…
-
Formula to find data in table with multiple columns based on 2 critera
I am looking for a formula that will look at this table and pull the hours per week based on 2 criteria – group and week. Right now, I have the tables separated so that I can use a vlookup formula. But that means I have to have 5 different formulas, 1 for each group. =IFERROR(VLOOKUP(ROUND(($[First Receive]@row - $[Week 1…
-
Selecting the best Smartsheet for your project
I need to make sure I am selecting the correct smartsheet workspace for my project. I am trying to create a workspace to track and share client implementation. How do I add a Start date and then the sheet automatically adds task dates, as well as deadline, completion percent dates without having to add all manually. I seem…
-
Templates
Just watched a training video , and he showed a template(s) named "Weekly Task List Template " and "Daily Task Manager " cannot locate this group of templates anywhere ?
-
Data Shuttle Errors (Column mapping, other?)
Hi All - We are using Data Shuttle to offload content to sharepoint for the first time, and I've made sure my headers match, etc. I've tried both CSV and EXCEL. I'm at a loss at this point, and have seen others suggest similar issues without much detail on 'resolution' - any insight is greatly appreciated. Same error, same…
-
User Report
Hello, I unshared a user from all of our sheets about a month ago using the Admin Control Center. At one point, this user had Admin access on many sheets. When I run the User Report, the user is still showing as Admin or Viewer on sheets they were unshared from. I’ve manually checked several of these sheets and confirmed…
-
BULK Apply Conditional Formatting on multiple widgets.
I’m not sure if this has already been asked here or if there’s an existing Enhancement Request, but: is there any way to apply conditional formatting to multiple widgets in a dashboard at once? I have a large number of widgets, and applying conditional formatting individually to each one is very time‑consuming. Ideally,…
-
How to Display Proof Images on a Dashboard
I am looking for a solution to create a workflow that automatically displays the most recent Proof version as an image on a dashboard. I have created both a report and a sheet that mines only the rows that have proofs into a stand-alone sheet/report but are not able to find a way to have Smartsheet pull the proof image to…
-
Remove links from the entire sheet
I made a copy of a sheet to test something and forgot to uncheck the option to keep the links. Now the Sheet I copied has all of the linked rows and the sheets where the data populates from now show links to the original and to my copy. Is there a way to remove the links from my copy in hopes it removes the links from the…
-
Uploaded sheet on Teams does not allow switch from grid view to card view (or other views)
Hi fellow Smartsheet users, I have an issue of changing the table view to card view after uploading the sheet in a Teams chat. On the Smartsheet website, there is an option of switching views to card view or any other views. However, this option is not available on Teams, and we had troubleshoot it for a while and to no…
-
Missing Send Update Request Option on Sheet
I am no longer able to right click on a row or use the 3 dot menu to send an update request. When I created this sheet, the option was available but I cannot seem to find it now. To my knowledge, nothing has changed with the sheet permissions/settings. I am attaching an image of the menu I get without the Send Update…
-
Microsoft Teams Integrations - Option to Send Auto Alert to Group Chat instead of only Teams Channel
Within our organization, we utilize Microsoft Teams for almost all communications. I have been researching and troubleshooting for a bit and have found that automated alerts can only be sent to Teams Channels instead of Group Chats within Microsoft Teams. If I have misunderstood, or someone has an idea to bypass this,…
-
Move attachments between sheets
Is there any way to move attachments between sheets without the clunky "Move a Row" or "Copy a Row" automation?
-
Can't change business address
Hello, I tried to change the business address in account administration, however, when I tried to save the new information the system generates a prompt saying "invalid payment type of action" - which makes no sense. Can anyone from smartsheets please fix the bug?
-
01/01/70 View Activity Log Issue
Hi all, I see more and more issues in multiple of my sheets using date. The issue is for every data column including created date and just date. This results in data not coming through properly in aggregations, indexmatches with date in it, column formulas etc. Is anyone else experiencing the same issue and how could this…
-
I cannot change data source on chart widget
I am the owner, admin and creator of a dashboard. I have used smartsheet for many years. However, after creating a dashboard several months ago, I no longer am able to edit the dashboard. Specifically, I can no longer change the data source on any of the charts I have created. It is greyed out without any options. This is…