-
Resource allocation not matching project sheet allocation
A member of my team is allocated resource on a project. The issue is that although they are only allocated to 85% on this project/task, it is showing as 100% in my resource view. I only have view access to the sheet and cant change that but am confused as to why this would be doing this
-
Deactivate temporarly all "Alerts & Actions"
Hi all, i need to make some updates on my spreadsheets, that were not made on due time. But i don't want to confuse people by triggering notifications and alerts of actions already completed. Is there any way of deactivating all the "Alerts & Actions" at the same time, and then activating them again as soon as i got…
-
Changing Colors of Gant Charts
Is it possible to change the colors of the main timeline bars (not just sub-timelines) on a Project sheet in Gantt view? I do not like the grey.
-
Referencing other sheets
Hello, I have a sheet where I want to add totals in 7 other sheets for January - December for several drugs. When I get to February, it tells me I am at the max for references. I think it was 15. We have 7 squads...each squad seizes many drugs per month. I am trying to get the grand total of the drugs for all 7 squads for…
-
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
