-
All sheets gone but the templates left
I am a licensed user. I logged in to the Smartsheet today and found all the sheets I had are gone. No matter whether shared or unshared they disappeared, even the workspace I created for my team. the only thing I have on my Sheet page is some templates I used for tests long ago. I am not sure what is going on. But that led…
-
Global Update Workspace Logo and Colors
Hoping there will be a future ability to update all Smartsheet workspace logos and colors from an administrative perspective across the board. At the very least creating some type of API call to revert to Account Color Settings and Logo so someone doesn't have to manually click on every workspace (I personally have 232…
-
IF OR Statement For % of completion
I am trying to write a formula that returns the status of the project based on a column labeled as "% Completion", if the % of completion is 100% then status should say complete. if "% of completion" is 10% then status should be in progress. This is what I have come up with but it's giving me "INCORRECT ARGUMENT"…
-
How do I copy a row between workspaces?
I have two workspaces: 1) department-wide 2) my workspace. The owner of 1)department-wide is my supervisor. I am an admin in this workspace. My supervisor does not have access to my workspace (#2). I want to run a workflow that copies a row from a sheet in workspace #1 (department-wide) to a sheet in my workspace (#2).…
-
Merged: Folders that hold multiple Workspaces
This discussion has been merged.
-
Why isn't our column formula updating on its own?
In our column formula, we have a date formula based on TODAY(), however, it does not seem to update automatically when the month changes. How do I get it to update automatically at the beginning of the month?
-
Sheets in Reports
Hi there, I have a question and an answer is greatly appreciated! I have a report that pulls data from standard sheets across all workspaces we have. I need that same information to be pulled from every newly created workspace in the portfolio without me having to add those sheets manually. Is there a way to automate that…
-
Desk reservation form
Hello, How do I create a form that will allow a user to reserve a desk for a particular day and remove that desk from a list of available desks? Within the same form, I will also need to allow for recurring dates? For example: If an employee comes to the office every Tuesday and Thursday, they could reserve that desk for…
-
Accessing a Form from the Workspace directory
Our team utilises a Form to enter Defects (Snags) as the construction project comes to a close. The form resides in the Defect Register. When a user is in the field, they must access the project Workspace via the Smartsheet App, navigate a few folders to the Defect Register, open, select the 3 vertical dots, go to Forms,…
-
Best practices for Smartsheet clean up/declutter
Hi, Our company has a lot of Smartsheet's and currently a lot of inactive ones (1500+). I've been tasked with finding a way to declutter/ archive off a lot of these inactive sheets. I'm wondering what the best practice for this would be as I'm new to Smartsheet and as far as I'm aware Smartsheet doesn't have an archiving…