-
Merged: Visible Column Description in Report
This discussion has been merged.
-
How do I remap my Smartsheet Form?
I have a Smartsheet form used to collect and manage training requests. The form is set up with a client selection dropdown, followed by additional fields specific to each client. For instance, selecting "Dignity Health" in the client field triggers the appearance of Dignity Health-specific fields such as Client Host…
-
Need to reference distinct values from another sheet
I'm looking for a formula to automatically pull distinct values from a column in another sheet to use in a reference sheet. Example: Source sheet 1 has a list of [CustomerID] and various other columns. Some [CustomerID]'s are listed on multiple rows. Reference sheet 1 wants to list all the DISTINCT([CustomerID]) values, so…
-
Merged: Show or hide columns by grouping (in Grid View)
This discussion has been merged.
-
Email Addresses from Contacts
Is there a way to convert / extract the email address from the values in a column set up as a contact? I have a need for the email address associated with contacts. Thanks
-
How do I import an entire column from one sheet to another without getting #unparseable
I need all of the information entered in a column of sheet A to feed into sheet B. Does anyone have any advice for this? This is the current formula we're trying that's showing up as unparseable: "=INDEX({A. Wash Schedule Range 1}, MATCH({A. Wash Schedule Range 1}),@row, 0)" We're gotten "=INDEX({A. Wash Schedule Range 1},…
-
Copy and Pasting Multiple Rows from Excel into One Multi Dropdown Select Cell in Smartsheet
Good Morning fellow smartsheeters!!! Is it possible to copy and paste multiple rows from excel into one cell in smartsheet when that cell is apart of multi dropdown select? For my use case, Each Market as an offer associated with it in column D. So essentially these markets in column c are grouped by the Offers in Column…
-
Dynamic Date Calculations
We have different project types, and each project type has a different number of days is needed to complete a task. We have a sheet of about 30 rows that defines based on what project type, how many days it takes to complete the task. I want to make a date column to say "this is when this task is due" but I'm not sure if…
-
Non Licensed User - Editor Access - Update Columns
Hi - Has anyone experienced this? I have an unlicensed user shared to a sheet with a form with Editor access. I can see in Activity history she was able to change column properties for a column from Text to Date. Has anyone had this happen? I am wondering if she somehow edited the form?
-
Column ID visible in Column Settings
The column ID has been removed from the Column Settings. It is now accessible only through Bridge. I would like to request that it be added back to the Column Settings.