-
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…
-
Merged: Need ability to share a Workspace with all users
This discussion has been merged.
-
Sharing a workspace with the company
Hi all, Is there a way to share a workspace with the whole company/domain without adding them all individually or in a group? I cannot keep the group up to date and asking teams to request access may be a deterrent to them trying (and even so - dependent on the owner accepting in time). I cannot publish the sheets/…
-
Omit records with No data on Charts
I have a Workspace with a form that feeds into a sheet Then I have a calculations sheet that adds up everything (most of which us SUMIF). Now a few of these Workstreams (which are in a dropdown list on my form/main sheet do NOT have any data currently associated with them. But that will change. And like I said these…
-
Update same Column Cell value
I have two columns id and Name . when user enter something in column Name in any cell . all the rows having the same id name Colum should be updated to same value entered by the user Any way to do by formula or workflow user enter abc in 1st row with id 1 id Name 1 abc 1 2 3 1 2 output id Name 1 abc 1 abc 2 3 1 abc 2