-
How to Add Existing Sheets and Reports to a New Workspace
Hello, Our team has been working with an existing Sheet and Report that has been shared with multiple people and been in existence for months. I don't see a way to add the existing Sheet and Report into a new workspace that we want to create. I only see options to create new sheets, items, etc.. Is there a way to add an…
-
Collaborator name vs email appearing in Share list
When I share a Workspace, some collaborators appear in the share list with their name only and others with email only. In both scenarios, their Contact includes first name, last name and email AND both are free collaborators. I need them to appear/be listed by name, instead of email only. I've removed and shared again to…
-
Formula to Arrive Todays date
Is there any option today reflect today's date in smart sheet. I tried typing =TODAY() in smart sheet cell and returned with #INVALID COLUMN VALUE Its similar to MS Excel I used this formula in the cell I require
-
workspaces and templates not appearing in Zapier
I am the owner of the workspaces and templates - Admittedly I do not know if this in on the Zapier side, but I seem to be missing several options when using Zaps to create new sheets from a template. The system does not see the destination (workspace) I want to new sheet to go in, nor the template I want it to create. What…
-
Creating a community forum through smart sheet
Hi everyone, I'm pretty new to smart sheet and was wondering if Smartsheet is able to be used to develop a type of community forum / discussion board within smart sheets? Like could we develop something similar to this Smart sheet Community and have it accessible through a portal? If you have any helpful resources, that…
-
Changing Ownership of Workspaces
Hello, I need to change the owner of a couple workspaces I'm the owner of. I read the instructions but it's still unclear what steps I need to take. Do I make the person the owner of every item in the workspace first and then the owner of the entire workspace?
-
Collaborators can't sort rows
I've been using Smartsheet for years, and this is the first time I've encountered this issue. I have a number of free collaborators in a shared space, all having access to 6 sheets. They all have the same permission level: Editor - Can Share. At first it was working fine, but then people started emailing me saying they…
-
Renaming Workspaces
Is there a way for admins on workspaces to be able to rename them, or is it only workspace or sheet owners that can do this? Since the admin has full sharing/editing rights, it would be helpful to have them be able to do everything the owner can do so there isn't a bottleneck with every change having to go through the…
-
Running a report with multiple sheets, columns not populating
Hello, I am attempting to run a report with multiple sheets and/or a workspace (I have tried it both ways) the criteria seems to work fine but when I attempt to show a column from one of the other worksheets it does not populate. Any suggestions??
-
Count occurrences of each variable of a multi-dropdown list
Hi, I'm building a lease administration tool to help negotiate some leases. Each row (lease) has several stages (preliminary, negotiating, at lease, executed lease, open). I want to create a dashboard metric to show how many rows are at a particular stage: Preliminary - 5; Negotiating - 3; At Lease - 7, etc... What would I…
