-
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…
-
COUNTIF formula returning 10 extra blank lines
I wrote a formula to count the total number of unassigned purchase orders in my sheet, which looked to be working at first glance, but upon comparing it to the actual data in the sheet, realized that it is counting 10 ghost orders. This is my formula: =COUNTIF({Assigned}, ISBLANK(@cell)) The Assigned column is a contact…
-
Can a duration column with dependencies not pull data from a created date column?
I have a sheet with a created date that is generated by the system upon submission of the project. I wanted to create a column that tracks the duration of the project from submission to delivery with dependencies, but when I click the drop-down under project settings it doesn't have that created date listed. Is there a way…
-
Ability to change default background color and background color in sheets
I think the ability to change the background color in smartsheet would be very beneficial in helping avoid eye strain. Most of us are looking at white screens all day and our eyes get very tired and strained. Even with special blue blocker glasses I still notice the eye fatigue. Please consider adding this feature in a…
-
Count from all project sheets in the same Workspace
We have multiple projects (25+) using the same template in a workspace. I am able to create a report that shows all of the upcoming task by adding the entire workspace to the report and creating the right filters. I want to output a count of all of these tasks and use that value in a dashboard setting. Smartsheet does not…
-
Find middle number using LEFT and RIGHT Formulas
I have a column with dates that look like this 2022-10-18. I am trying to create a formula using LEFT and RIGHT to only give me the month (in this example = 10) Please help, thanks!
-
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…
-
Did the ability to 'Favorite' a folder disappear?
I have several folders still in my favorites, but I have notices recently I am unable to mark a Folder as a favorite. The start is missing from the title to do so, and it is not a right-click or ellipsis option. Since I have entire folders already in my favs, it had to be there at some point. What gives?
-
Move Row Automation
Hi All- I have a process where I copy and rename a templates folder (the contents are not actually templates but standard forms) from an admin workspace to an active workspace. Within the copied folder, one sheet uses the move row automation to archive a block of rows to another sheet within that same copied folder. The…
-
Folders in Bridge Workspace
Currently for enterprise licenses (maybe for all licenses?) the enterprise shares access to a group Bridge workspace or 'directory', if you will, where all workspaces for all users reside. As a user, I can create multiple workspaces for my different needs but I cannot keep all of my workspaces collected together. One worry…
