-
Issues Opening the Sheets
I'm receiving this message every time I try to open my sheets. I'm the only admin user. I have already performed proper troubleshooting, such as clearing the cache, logging in incognito, and logging out and back in, but the issue remains unresolved. It's been a few days, and I'm unable to track our projects and this…
-
JOIN-COLLECT and Contact
Hello, I am trying to use JOIN-COLLECT to populate a cell with a contact by pulling from another sheet. However, when I use this formula it populates the cell with the name of the contact as a text string, but does not populate the cell with the contact itself. Both the column of cells being populated and the column the…
-
Adding attachments to a generated document.
I’ve created an automation that generates a document and forwards it to the individual specified in a cell. The line item also has several additional attachments associated with it. Is there a way to include those attachments with the generated document?
-
Request an Update weekly automation only worked once and I can't figure out why
I have an automated workflow set up to run weekly and request an update when the project is in certain statuses. The automation only ran once and now it's not working even though I have it set up to run weekly. I need help troubleshooting why this isn't working.
-
Raffle Type System in a Smartsheet Form
I am looking at trying to build a multi-select option raffle form. Lets say a form user has 5 options or "tickets" they can put into a bucket of goods for a raffle. I would like for the user to put in any combination of entering tickets per good that they can with the five tickets they have. I will put in a picture of what…
-
Multiselect Dashboard Widget HELP!
Hello! I am attempting to create a dashboard widget that shows me how much budget we are spending in each segment, and in what category. The source sheet contains these columns… "Budget" - text/number column "Category" - dropdown list (restricted to list values only) "Segment" - dropdown list (allows multiple values per…
-
Shared Workspace not showing up
2 workspaces were shared with me by the same person but only 1 of them populated in my workspaces. The one that actually showed up depends on the second so I need both. I have the notification and email that the second one was shared with me, which I can click on and access the workspace. But since its not in my workspaces…
-
Dynamic View Predetermined Fields
I have a form that is completed by 16 different entities for 57 unique roles, filling a master sheet. I want to utilize the Dynamic View function, but also have prefilled fields and use a MATCH function from the master sheet to the dynamic view to match the input to the unique roles. The purpose is that there are a finite…
-
Unable to Edit Sheets After License Renewal (Owner Access Issue)
Hi everyone, I’ve been a Smartsheet user for over 3 years. However, after renewing my license in December, I’m no longer able to edit any sheets or projects — even those where I’m clearly listed as the Owner. I have a Business plan, the renewal has already been paid, and this issue started only after the renewal. When I…
-
Smartsheet Employee Dashboard functioning like an app
Hi there I have created a Smartsheet Dashboard for each employee, with sheet visual icons related to their worksheets. It serves as a quick link and hosts only the sheets they need to access and work on. The Icons are categorised as per our company's production and accountability structures. It resulted in no further…
-
Automation Group Deactivation
It would be great to be able to click a block of automations that can deactivate and reactivate automations as needed especially when fine tuning or making improvements on a sheet so that a notification does not go out in error. This would also help when you "save as new" a sheet for another project where you want to keep…
-
INDEX - Collect question
Hi there, I have a project where in the project plan, based on the start date selected for a task, I'd like Smartsheet to reference another sheet (which is the table of Sprint, Start Date, Proposed Completion Date, Sprint Label) and populate the Sprint Column with the correct Sprint Label). So the formular should check…
-
Sorting stopped working on existing sheet
Hi, I saw a few posts about sorting not working properly, but none of them had a solution and I'm not sure if my issue is the same. A sheet I have been using and adding and removing rows to/from over the last 6 months suddenly stopped sorting the date column in ascending order for new rows. No hierarchy or filters in…
-
Why do all sheets now need to be part of a workspace?
I am trying to set a workflow for an existing sheet, I have Admin permission. Once the rows meet a certain criteria I need them moved, one sheet to another. I created the new sheet, to where the rows need to be moved, which makes me the owner. However, when creating the new sheet, it creates a whole new workspace, like…
-
Saved Mapping populating PDF with random letters/characters instead of data from columns.
I work at a company that has used the document generation feature for a while to create cover sheets for jobs we're bidding/quoting. It's a super simple PDF that has worked well for a while. Today it stopped working and started populating the fillable PDF with complete nonsense like "e~îÉå]mêáåÅÉíçå" and "MNLOSLOS". I've…
-
Merged: Allow comments to locked rows or allow for locked calls vs rows
This discussion has been merged.
-
mailto: Function in Sheet Cells
Imagine the following situation: you’re working within a worksheet and want to add a hyperlink to a cell, you can reference a URL or another Smartsheet file. But I’d like to reference to an e-mail address. E.g. we got our suppliers names in this cell, and want to write them as fast as possible a message. And by just…
-
Pivot's disconnecting across Workspaces
Hello, I come with an issue the likes of which I haven't seen before. On 12/11, numerous Pivots in workspaces I own all broke. These Pivots house employees as columns, and their respective training hours. The Activity Log showed that all data suddenly went to zero. Then, over the next few seconds, new columns of the same…
-
Accessing Project Plan from someone no longer with the Org
How do I access a Project Plan that was owned by someone who is no longer with the company?
-
I’m not receiving push notifications on my iPhone and iPad
“I’m not receiving push notifications on my iPhone and iPad, even though other users are receiving them. I used to get notifications previously. Over the past month, I only see a badge showing the number of notifications, but when I tap on it, the notification screen just keeps buffering and no notification content…