-
Saving over other entries
I know SS will tell me when another user is viewing the tab, and it will tell me when they make changes so I can refresh. The challenges we're facing are: there's a good 30-45 seconds before SS tells me that someone is viewing the tab. That's plenty of time for them to get in, make a change, save it, and have me save what…
-
Find the Max and Min value in a column
Hi, I have a sheet with a single column that has a large range of numbers. I would like to use conditional formatting to highlight the highest number and the lowest number within this column so its easy to see when viewing the sheet. I can use the functions Max() and Min() to find the highest and lowest values, but these…
-
Schedule Cell Linking w/Lag
I have linked multiple project schedules together, but I'm wondering if there is a way to add lag time between the links? Currently the finish concrete completion date of the first becomes the clearing and grubbing start of the second, but I'm wanting to add a one week lag time between the two while keeping them linked.…
-
Master Project Sheet vs Master Project Report
We are looking at implementing either a very large (roughly 160 columns) master project sheet or a master project report. If we go with the master project sheet, teams would work off reports to update their respective data. If we go with the master report, I would aggregate specific data from each team sheet. The end goal…
-
Possible to do a bulk delete of sheets?
Ownership for some sheets that are shared with our VP of the PMO was transferred and when he got the notice he decided we need to clean up (delete) our Smartsheet ancient history. The number of impacted sheets (older than 3 months) is laughably small and I can easily delete them manually but I can't see them since I don't…
-
Misaligned Selected Box in Smartsheet - GUI
Hi, I have noticed the following after using smartsheet on Windows7 and IE 9.0. It looks like the selected box is mis-aligned which is offset from the box that youa re typing in. I have to switch to a new sheet and back again for it to disappear, but it eventually comes back. Any help would be much appreciated. Kind…
-
FORMULAS
I have a smart sheet for job progress I have indicdual lines of % of jobs what formula do I use at the top to get the overall % of all jobs.
-
If I lock a column, will that column move when a row is moved to another sheet?
I was going to create a column and lock it/and hide it - this column will hold all of my formulas. When a row is moved to another sheet, will my locked column stay put? I need to hide my formulas somewhere on my main sheet but a lot of moving is done by others and I don't want it lost. Thanks!
-
Display jobs for the week and who worked on it?
I want to create a sheet that can show the jobs for each week and who worked on it (multiple people can work on it, due to different departments).
-
Approving Changes Made to A Shared Sheet
Hi all, long-time listener, first-time caller. I have been tasked with discovering a way that a sheet owner can control updates being made to a shared sheet through some form of 'approval' feature or process. My scenario is this: there is a master sheet displaying all approved, company-wide projects, complete with columns…
