-
Offline Usage
I see back in 2015 there were some posts about not being able to use SmartSheet office Is this still the case? and in so, does anyone have any tricks or ideas to get around this Many Thanks in advance
-
Reporting on Activity Log data without exporting to excel
I am looking for a method to query/report on activity log data without exporting to excel and then importing back I into smartsheet. For example: I need to expose via a Dashboard the number of times specific Dashboards and Sheets are being accessed. Currently activity logs are exported to excel; a pivot table is created to…
-
Split-screen auto populate?
Hello all! I have a smartsheet that is always open in our warehouse to let the guys know when an item needs to be shipped; the line is added by our procurement team. After the warehouse personnel complete a shipment, they mark the status of that line as complete and save. The line then gets crossed out but stays in the…
-
Live data in smartsheet
Trying to pull data out of our ERP (epicor) probably .csv format and keep it continuously updated to avoid manual data entry as much as possible. any ideas about how to do this? i am trying to use the data uploader but keep getting this error message. Thank you for any help in advance.
-
Keyboard Shortcut to attach a link in a cell?
Hi, Is there a keyboard shortcut to attach a link in a cell? I know that I can right click on a cell, then click on hyperlink to put in a link. It would be a lot faster if I could just use control K on my keyboard similar to outlook and excel. Any thoughts?
-
Importing New Project and Having it automatically added to our drop down menu in forms
Good evening We have forms we created where one of our form entries is the name of the project. When we create a new project in smartsheet how can we make it so that the project is automatically included in the form dropdown so that we do not have to manually add the project to the drop down of every form? Thank you
-
Circular / Blocked Reference (Vlookup)
I have a problem with 2 sheets reading each other’s data through a VLOOKUP. The same problem was posted on May 30, 2018 by scott.barrett. Obviously it is not solved. My sheets also work perfectly for periods of time, and then start returning #circular or #blocked data without any changes to the sheets in almost every 2…
-
Processing Limitations: List of formulas in order by relative processing power required?
Hey Community! One of my first requests. I dug around and so far haven't found anything, but my apologies in advance if this has been addressed elsewhere. My company has been bouncing off sheet limitations for a bit now, yet none of our sheets are anywhere near 10,000 rows (I separate into logical volumes as often as…
-
Difficulty Printing
Im a little miffed at the amount of discussion on this topic, dating back years... and Smartsheet has not fixed the problem. I am not a Tech guy, but whatever the reason is, just make it easier!!! Its way too complicated to print a sheet onto one sheet of paper and keep it scaled right. is there not some programming…
-
SUMIFS - Contains value in cell from another sheet
Hi All, I want to create a "Total Vendor Paid Amount" column on our "Main Dashboard". This column will need a formula that pulls information from another dashboard called "REO Vendor Invoicing (3)". I want the formula to sum the total invoices paid, in the "REO Vendor Invoicing (3)" dashboard, of jobs that contain a cell…
