-
How can I get the sum of one column meeting two conditions
Trying to get multiple conditions and sum up total billable. Where Manager = John Smith in one column and Invoice Date = January in another column Getting the #UNPARSEABLE error =SUMIFS(AND(Manager:Manager, "John Smith", Invoice Date:Invoice Date, MONTH(@cell) = 1), [Billable Total]:[Billable Total])
-
Mass producing Dashboard with web content widgets
hello everyone, I created a dashboard to act as a huddle board for the business meetings and we will need about 100 different dashboards but dont want an update on one board to impact the other boards. We used web content widgets and when we "save as new" to make a copy - we are having to go in with the unique publishing…
-
How to automaticaly share a PM to a workspace created by blueprint
We have control center and we have a blueprint that runs based on an automation. in the intake sheet we collect the name and email of the project manager. When the blueprint creates a new workspace we would like for the blueprint to share the workspace to that project manager as well. important to note, the project manager…
-
Workspace sharing option that doesn't allow "Save As New..." to protect against IP theft
The "Save As New.." feature is great and I use it all the time to duplicate Workspaces and use sheets as the templates for new projects. However I am conscious that I share a lot of really good stuff with other people outside my organisation, and there's nothing to stop them from saving a copy and using it themselves -…
-
Dashboard integration with powerpoint - or print preview function
Currently to load our projects from a dashboard to powerpoint we 'print to pdf' and then snip to paste to power point. Is Power point integration a reality? If not is a print preview function possible to clearly show where each page cuts off? This is a monthly cycle for my team to reformat/respace depending on the amount…
-
Dashboard breaks after removing an Admin (original owner/builder of Dashboard but not current)
We have a Dashboard (several Dashboards that this same behavior happens on) that was built by one person. The Ownership for the Dashboard and ALL associated items (Metrics Sheets, Reports, Source Sheets, etc.) were transferred to another person. The person who built the Dashboard originally (who is no longer the Owner of…
-
Best Practices for Employee HR Dashboards
Hi - I am trying to create a dashboard for each employee in our company that contains their personal HR data (such as time off balances). I've created several reports that I would like to share with each user on a dashboard. Normally, I would utilize the "current user" feature and create one report for each element, one…
-
Sharing without showing who else it is shared with
Is there a way to share a sheet without showing who else the sheet is shared with? I want to give access to a client to enter information on a sheet but I don't want the client to see who else the sheet is shared with.
-
Sharing folders
Since Workspaces is not conducive to individual permissions, we are trying to use the standard folders under "Sheets". One department has close to 100 files in Smartsheet. We want to use Smartsheet in other departments as well, but would like to organize the departments by folders. With each Sheet, Report, and Dashboard…
-
How to share filters?
Can someone explain to me how to share a filter with another person viewing the sheet? Thanks