-
Can you only indent to 1 level or is there a way to allow further indents?
Can you only indent to 1 level or is there a way to allow further indents?
-
Live Data Connector
I have a Smartsheet linked to Excel (using the Live Data Connector). When I refresh the data in Excel all data refreshes. Is there any way to limit what appears after refreshing? I only want to show what is new and/or what has been changed in Smartsheet?
-
Error When Saving Smartsheet
I have been searching the existing posts for something like my current experience, to no avail. This morning, I have been having trouble with my program management sheet. All of our current projects roll up to this sheet, and this sheet goes to my VP. It is large, but has always been large. I haven't changed anything…
-
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.…
