-
Values not appearing in linked Excel table
I have a report that pulls from several Smartsheets. When I run the report in Smartsheet, I see all my values appearing. However when I refresh the linked report in Excel, not all the values appear. My values are text/number so there is room for numbers as well as "N/A" -which we manually enter. I have another, very…
-
Opening Worksheet in New Browser Tab
When navigating through and opening several sheets, it would be helpful if there was the ability to right-click on a SmartSheet and open a sheet in a new browser tab. Currently we have to open a new browser tab, navigate to smartsheets, then find/open the sheet.
-
Timesheets
My firm uses Smartsheet for timesheets and client billing. There are now 22 people filling in individual timesheets. There is a Client Name column with a dropdown box with all the client names, probably about 100 now. Monthly, I manually go into all 22 timesheets and update that dropdown box with new client names. This…
-
% Calculations On children
HI Community I have A Quick Question On % Calculations I have a Payment Sechdule Which has a a main Name For example Wall Framing Under Wall Framing i have indent Wall framing on Floor 1, Floor 2 etc, And i ran =SUM(CHILDREN()) To calculate Total We charge on Wall framing Now For my customer i want to send only The Main…
-
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…