-
Combining Data from Multiple Sheets in a Sight
My team and I are having a problem with the combination of data from multiple sheets showing up in our sight. Originally, we had a couple sheets that all had formulas returning data at the top of each sheet. I then cell linked the cells from these sheets to allow one sheet to add them all together. This then allowed just…
-
Automate End Month Date
Hi , I have started a Sheet to manage tasks for of the payroll Firm's I run I need to get into 1 cell automatically last date of the month so if its February its the 28th if its Jan should be automatically the 31st Which formula can I set up that it should automatically be set for end date of the month? so i can get set…
-
Range Starting point and then the rest of the row.
Hello, I am trying to reference an ever growing range in a COUNTIFS formula... but it starts at about Cell 150... I would like to have the range 150:infinity... any Ideas?
-
How long for data to update across linked cells and reports
On more than one occasion, upon updating information in one sheet, and saving and refreshing all involved sheets/reports, the data was not visible in other sheets/reports. Is this an update delay, browser caching, or something else? And, is there a general amount of time I can tell users? Two scenarios I've experienced: -…
-
Webform - Comments on the bottom
On my webform it has a spot for comments (for the user), where do those comments go? they are not on my sheet - do I need to have a "Comments" Column???
-
Smart Sheet for a Print Shop?
I own a medium sized print shop and I am exploring software solutions to accommodate my client and job database, job tickets with product specification, production management, work flow etc. I currently have a database of around 80 000 completed job tickets that we use for reference. Just about every job is different. We…
-
Outage?
Is there some kind of outage with SmartSheet? My files have errors and won't print to pdf!
-
Outlook Add In won't connect on new Windows 10
Just switched machines to a WIn10 box. On my old machine, I lived ate and breathed through the Outlook Add In to get things over to smartsheet. Now on Win 10, I'm of course prompted to "connect to smartsheet" when I select the smartsheet add in from the menu bar. That is to be expected, new box, right? However, when I get…
-
Adding information to templates
I am trying to work out the best way to do this. I have an evolving list of products (hundreds and hundreds) that can be ordered, and 29 people (only - this is set) who can order them for a Bulk Buy once a year. My current plan, was to create a Template, then have a sheet for each person. This way I can request them to…
-
Enhancement Request: Allow downloading Activity Log
Today I ran into something I occasionally run into: wanting to enter an exception to an Auto-Number column entry. Example: I have a sheet with an Auto-Number column. It has been in use for a while. Maybe it was created by a customer and I'm coming in to help. What I want to do is add a row or two at the top of the sheet to…