-
Average of lease $ amounts in a certain region
I would like to see the average lease amount per region. I am cross sheet referencing. The formula for the average works. But when I add in the second part (countifs) to make sure a PE GL Checkbox has been checked and to specify a region (I do a cell reference) it doesn't seem to work. For instance, in 1 region I do not…
-
Sorting Issues
I'm still looking into this but has anyone had any issues with the sorting feature? We have one sheet that 17 people are constantly working in a day. (All Editors and 2 Admins if that makes any difference) This morning we SORTED several rows and HOURS later someone who had the sheet open, saved their data and INSTANTLY ALL…
-
Sharing Sheets to Multiple Workspaces
I was wondering if I could have a sheet be located in multiple workspaces simultaneously. For example If I wanted to have individual workspaces for each project I am working on, but also have separate workspaces that would allow me to see overviews for ALL projects, all pulling from the same sheets.
-
Unlicensed Users
I thought I would share this information to save someone else the time. I recently finished a trial with Smartsheet and needed to justify the cost of licensing to continue using the tool. Here's a spreadsheet I started. Once I got this far, I had convinced the appropriate audience and the licensing is in the works. This…
-
Notification to someone not shared on a sheet.
We have a Smartsheet for Employee time off requests (Shared to the Department Managers and HR) Employee completes the request form which triggers an approval request to the department manager. Upon approval/decline a notification is sent to HR - Here is where we’re missing something we also want the notification to be sent…
-
Knowledge Management
Does Smartsheet have a knowledge management system? I am a KCS Program Manager and always on the lookout for new technology.
-
Hiding who is viewing a sheet
Hello! So I have been using Smartsheets for a short while and I think it's fantastic! I do have a query though - Is there a way of hiding who is viewing a sheet? We have a sheet with a massive amount of data on there which is shared with numerous suppliers we work with. They all require the data for different uses, some…
-
Restricting Send Row
Is there a way to restrict where a row can be sent through the Send Row function? I see that the Enterprise plan has the exact domain whitelisting functionality that I'm looking for but that's not a feasible option for us. Has anyone come up with a solution to prevent an authorized user who needs full edit rights from…
-
Active Faces
Hello, I am a new User to Smartsheet however after sharing a sheet with a number of people I am finding that the "Active Faces" icons associated with a shared user accessing the same sheet at the same time are not showing on my screen (next to the "Share" icon). I am also finding that the pop up messages (not the…
-
Viewing a Report via a link without the need to be logged into SmartSheet
I have a register which generated various reports by location. I want all staff to be able to just view it without the need to have to register and log in. How would I achieve this? The reports are generated and ready to go. Will I have to do the tedious process of exporting them to pdf then placing them on the intranet as…
