-
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
-
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…
-
Change calendar (column type: date) to years (not months)
Hi all, Just a quick question - when using the column type 'date' in a sheet, is it possible to make the calendar which comes up for selecting the date in question a 'year' calendar rather than a 'month' calendar? Many people using the sheet/form will be inputting dates from about 50 years ago, so a calendar by month…
-
Contact Formula from Latest Comment Column
Hello all - I'm looking for some formula help. Without getting to deep, I'm looking to develop a formula that can extract the emails from Latest Comment, regardless of their position in the comment, if/when they are added in the latest comment. I currently can move (1) email but not multiple ones. I then put it in a helper…
-
Merged: Hiding columns should work across all views
This discussion has been merged.