-
Setting Alerts At A Row Level Using A System Column
We are trying to set up the sheet so that when a particular task is checked off as "Received or Done" it sends an Alert to the correct team member. We have a systems column to allow us to set it up to be row specific to the task, but it isn't working. Please see the screenshot below. Thank you in advance for any help…
-
The "New Smartsheet Navigation Experience" is Great! TY!
The New Smartsheet Navigation Experience is GREAT! The #1 feature I'm excited about is Browser Tabs and Direct Links. Being able to copy the URL straight from the browser. I spent a LOT of time as a champion and mentor explaining how to get the URL to share a specific sheet. I really believe this will enhance the new user…
-
Issues changing rows/columns
I have owner permissions on a smartsheet that I need to make adjustments to. I need to delete/rename columns, etc. The options aren't coming up for me to use. Is there something different I should be doing? I didn't create the sheet but I am set up as an owner, so it should work, right?
-
Linking information
Hi Is there a way to link folder names and drop down list items to a cell? I could then f.ex. have a sheet with overall Project Info where i list a number of sub projects, then create a folder named through a link to the sub project name in the project info sheet. In the same way maybe i want to assign some sort of…
-
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…