-
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…
-
Anyone else experiencing EXTREME delays with cell linking?
I'm noticing SEVERE delays with cell linking lately. As in over 15 minutes before the cell populates. Our plan includes tech support, so I called yesterday. They said "up to 5 minutes is normal" I'm at over 15 minutes with no data being pulled down from the other sheet.
-
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…
-
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…
-
How can I hard code a cell based on a trigger?
BLUF: When I create an Invoice, I need the cell-link to my live price data to be severed. I currently have a Price sheet for my products that is updated frequently. I use Control Center to create Projects, which includes an Invoice sheet. I have a dropdown on my invoice sheet to select a product, and then I use Index…
-
Cannot create new Chart from a report
I can create a Chart in Dashboard from sheet well but from Report is not working now. I just try with simple Report (just contain 2 column Primary and Number) but cannot make the chart. Is there any changes recently right, because I haven't worked with Smartsheet dashboard for a long time and I remembered that I could do…
-
Auto Populate Cell Reference by field names
This is going to be hard to explain, but I'm hoping I can do it. I have a sheet named "ProjectSheet". Under Task Column I have multiple "Applications". Under each Application is a Project Stage (Data Gathering, Build, Post Go Live). Under each Stage are two roles (IC, IE) (Top - image) I have a second "Team_Dates" sheet…
-
Use Sheet Summary as cell reference for a different sheet
I'm using salesforce connector to pull my team's hours information in real-time. The Salesforce connector sheet contains sheet summaries that I'd like to use a cell reference for a different sheet. I can't seem to find the best way or formula to do this. I don't want to use a dashboard with report widgets because I prefer…
-
The "Master Program View" (Dynamic Sheet Aggregation)
Problem: Current Limitations Reports are "Flat" Lists: Current Reports can aggregate rows from multiple sheets, but they function as static lists. They cannot perform project logic (dependencies, duration calculations) across those sheets. No Cross-Sheet Critical Path: There is no native way to identify a "Critical Path"…
-
Help with a function to collect data from 2 different sheets based on year date
I need to extract information from 2 different sheets based on the name of the member organisation and the join year (i.e. DD/MM/YYYY). The 2 sheets have the same column titles, but one is for 2024 and another one for 2025. Where organisation joined earlier than 2025, then it needs to fetch the data from the 2024 sheet,…