-
Get Email from Contact Name
Formula or some option to get the email address associated with the Contact name. A name can be anything a user chooses (variable), but an email is not variable and can be used to do lookups more accurately than a name. (Relying on someone to type it in correctly is asking for trouble.) I currently use DataMesh to get the…
-
JOIN-COLLECT and Contact
Hello, I am trying to use JOIN-COLLECT to populate a cell with a contact by pulling from another sheet. However, when I use this formula it populates the cell with the name of the contact as a text string, but does not populate the cell with the contact itself. Both the column of cells being populated and the column the…
-
Why do all sheets now need to be part of a workspace?
I am trying to set a workflow for an existing sheet, I have Admin permission. Once the rows meet a certain criteria I need them moved, one sheet to another. I created the new sheet, to where the rows need to be moved, which makes me the owner. However, when creating the new sheet, it creates a whole new workspace, like…
-
Multiselect Dashboard Widget HELP!
Hello! I am attempting to create a dashboard widget that shows me how much budget we are spending in each segment, and in what category. The source sheet contains these columns… "Budget" - text/number column "Category" - dropdown list (restricted to list values only) "Segment" - dropdown list (allows multiple values per…
-
"Move row" automation option for "origin sheet"
I have a few Smartsheet solutions in place where a sheet is a destination for "Move row" automations from multiple sheets. For example a "Completed" sheet could have rows moved to it from 20 other "Active" sheets (each active sheet having a "Move row" automation to move rows at the end of each day when all checkboxes are…
-
Dynamic View Predetermined Fields
I have a form that is completed by 16 different entities for 57 unique roles, filling a master sheet. I want to utilize the Dynamic View function, but also have prefilled fields and use a MATCH function from the master sheet to the dynamic view to match the input to the unique roles. The purpose is that there are a finite…
-
Shared Workspace not showing up
2 workspaces were shared with me by the same person but only 1 of them populated in my workspaces. The one that actually showed up depends on the second so I need both. I have the notification and email that the second one was shared with me, which I can click on and access the workspace. But since its not in my workspaces…
-
Sorting stopped working on existing sheet
Hi, I saw a few posts about sorting not working properly, but none of them had a solution and I'm not sure if my issue is the same. A sheet I have been using and adding and removing rows to/from over the last 6 months suddenly stopped sorting the date column in ascending order for new rows. No hierarchy or filters in…
-
Accessing Project Plan from someone no longer with the Org
How do I access a Project Plan that was owned by someone who is no longer with the company?
-
Pivot's disconnecting across Workspaces
Hello, I come with an issue the likes of which I haven't seen before. On 12/11, numerous Pivots in workspaces I own all broke. These Pivots house employees as columns, and their respective training hours. The Activity Log showed that all data suddenly went to zero. Then, over the next few seconds, new columns of the same…