-
Calendar View of Project Status Progression
I have been working with a colleague building out a Smartsheet to track the progress of 54 projects she’s working on. None of the projects are time dependent, but each moves through 5 phases during the course of its life-cycle. The name of each project and its status is contained within columns of the Smartsheet. Her…
-
Sorting by Date Keeps Randomly Resorting
I have a Smartsheet that about 8 people all work from, we all sort by "start date" Ascending (1/1/26, 2/1/26, 3/1/26 etc.). However we all have to constantly resort as the rows will get randomly sorted sometimes. Why does this occur? How can we set it up to keep the sort as Ascending from the "start date" column? We do add…
-
Managing dates
Hi SS Community! I have a feeling this maybe a simple answer, but I have looked on the internet with no resolve: I have "Project Plans" for each one of my projects. I use dependency settings. For dates I have Start Date, Due Date, ESTIMATED NUMBER OF DAYS TO COMPLETE, Estimated Completion Date and Complete Date (Record)…
-
Extract Data from a replaced file in the Folder
Hello Team, I am currently using Data Mesh, to get the sheet updates from Sheet 1 (Source) to Sheet 2 (Target). Now, I am having a situation, where Sheet 1 (source) needs to be replaced on daily basis. The data mesh is unable to retrieve the replaced file. What is the solution Smartsheet can offer in this case ?
-
Inputting Contacts into Smartsheets
Hi Smartsheet community, question..my Smartsheet account is not allowing me to input contacts of contractors for project into my inspection reports. I have the correct information for each contact (ie. email and phone number). Would this be a restriction out in place on my company’s end or..I need answers. Any feedback…
-
Solution to analyze multiselect dropdown data and visualize in a reporting dashboard
Hello! I'm somewhat new to creating reporting dashboards in Smartsheet and I'm running into issues since one of the key metrics my sheet has is a multiselect dropdown. I'm aware that you cannot group by a column that has a multiselect dropdown, but what would be a workaround for that so I can visualize that data in a…
-
Health Ripple Effect Formula
On my project plans, I use a Red/Yellow/Green/Gray column called [Health], and I also use the stock [Predecessors] column. I'm trying to come up with a column formula so that if I change the [Health] value on a given row, it will update the [Health]@row value of every row downstream that directly or indirectly uses the…
-
Access problems with external users
Has anyone had problems with external users getting pushed into purchasing accounts? Most of our external users are able to view all of our dashboards without an issue, but one organization is getting warnings that their trial account is going to end and they need to purchase an account to continue viewing. According to…
-
Program Reports Editable based on Sharing permissions of Source Sheet
Currently if you create a report using a program as the source, only users who have at least viewer access to the source sheet on ALL of the projects created with the Control Center Blueprint can view the report. This creates a problem and misses a huge opportunity. The problem is that this is just the Control Center…