-
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…
-
No longer able to widen first column
I am an admin and the creator of a sheet but I've lost the ability to widen the first column -- the one that shows the row icons for comments, attachments etc. I can widen any of the other columns but not the first one, and the column is so narrow that I can't even see the aforementioned icons. Any idea what happened and…
-
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
-
The order in the form does not match with the order in the sheet
Hi group, I created a survey in Smartsheet and I see that the order of questions in the form does not match with the order of columns in the sheet. This may be because some questions were added later into the form and inserted between existing questions. The order in the form is the correct one. Do you know how to easily…
-
Sheet Formula
Happy 2024 everyone, I hope your year is off to a great start! I'm back requesting help to get some formulas working. I am trying to use the countif formula to count a column in a sheet. I am trying to get it to count all the dates in the column, but I also want to use to the formula to count all the rows with that same…
