-
Merged: Modify formatting in column headers
This discussion has been merged.
-
Importing Emails of Users, Smartsheet Not Converting to Contact First and Last Name
Hello! Has anyone figured out a way to load a column of emails or names, any combination really, into a contact column on a sheet where the user's first and last name appears rather than just the user's email? We're working on a large list that will be a source table for numerous systems and I want to user's contact to…
-
Order of the columns in a sheet
Being able to select or modify the order of columns in a sheet in bulk, for example: Creation date Column Type Alphabetical Order A-Z / Z-A
-
Back to Basics: Column Description To Show on Sheet
It would be helpful if a column description could be shown on the sheet as a row rather than indicated with an i. The work around is to use row 1 but this means, an additional column with a flag needs to be used to exclude this from reports. It also means that if have a column with a date, you cannot enforce dates because…
-
Missing Column
Hello, I have a column that is not showing up on one of my spreadsheets and I cannot figure out how to add it. I created the field on a form associated with the spreadsheet. The other fields I created that way showed up as columns, but this one did not. When I try to manually add it as a column it says that that column…
-
how can i reference a column from one sheet to another?
Hi Everyone Does anyone know a formula I can use to reference 1 column from a source sheet to a separate sheet? Thanks
-
Two checkbox columns to drive checkbox in 3rd column.
I have a pair of checkbox columns, which you can check for different criteria. I have a third column, also a checkbox column. I am trying to have the 3rd column be checked based off one of the 2 preceding columns being checked. I tried a formula "=COUNTIFS([Registered (DL)]:[Registered (DL)], 1, [Registered…
-
How to create a formula that will send notifications to specific users
Hello, Im trying to create a column formula that when a user selects a certain field, the responses will automatically go to a specific person/responder and will notify them of a task that's awaiting their approval. For example: someone wants more information about a specific oncology drug, (the "therapeutic area" column).…
-
Is there a way to export column descriptions with the sheet?
For data export needs, I was trying to see if it was possible to export the column descriptions when I export a Smartsheet to Excel. I know it will export comments and the sheet summary. Anyone know if exporting column descriptions with a sheet are possible?
-
Send report as an attachment - hidden columns
Hi, If a report is set to be sent as an attachment in an Excel file (File > Send as Attachment....), will it include the hidden columns? Regards, Joaquin
