Join the Smartsheet Community
Find answers to Smartsheet questions, learn about project management best practices, discuss the future of work management, and get how-to guidance for every Smartsheet use-case from fellow users and Smartsheet experts.
Discussion List
-
When move/copying rows, how to prevent new columns being added in the destination sheet.In Formulas and FunctionsIn Smartsheet's article, it's stated that "If the source sheet contains columns that the destination sheet does not, these columns will be created in the destination sheet when the row is moved or copied." Is there anyway to prev…Answered - Pending Review 27 views 5 comments 0 points Most recent by Maram Mohamed Formulas and Functions
-
No options for selection of destination sheet to copy rows with automationIn Formulas and FunctionsTrying to copy rows across sheets across workspaces (both of which I own) but when I go to select destination sheet nothing show up, blank screen. Any thoughts on what I may be missing here? Thanks in advanceAnswered - Pending Review 17 views 3 comments 0 points Most recent by Maram Mohamed Formulas and Functions
-
Report Grouping based on Multi-Select Drop Down, with the same "data" listed under multiple groupsIn Formulas and FunctionsI have a list of technicians who support calls from different phone queues. I need a report that will group all technicians who support each one. And as in any call center, technicians never support a single queue and will therefore need…Answered - Pending Review 19 views 2 comments 0 points Most recent by bonzemail Formulas and Functions
-
Countifs and check boxes.In Formulas and FunctionsGood Day, I keep receiving unparseable/ errors for this formula. I've typed this 20 different ways. I'm very lost at this point. =IFERROR(COUNTIFS({Oil Change Tracking Range 1}, [Zone:]@row, {Oil Change Tracking Range 2}, [Service Date:…
-
Relating sheets many to manyIn Using SmartsheetHi there. I am trying to design a set of sheets in Smartsheet to allow two different types of projects to be related to one another. I have species projects in one sheet and site projects in another sheet. I want to relate these two she…
-
Formula for referencing two columns in another sheet.In Using SmartsheetHello, I would like to add a formula for the partners' cell(image #1) to reference the two columns in another sheet (image #2). The current formula you see in the first image only references the Partners(existing) column. Any help is …
-
Date ValidationIn Formulas and FunctionsWe're tracking Open Enrollment for multiple clients on one sheet (below just includes one client). I have played with helper columns trying to find a way compare these dates with no success. Since they are on different rows, getting them t…Answered - Pending Review 14 views 2 comments 0 points Most recent by Marvin Daniels Formulas and Functions
-
Lookup formula still available?In Formulas and FunctionsHi there! Is the Lookup formula still usable in Smartsheet? I'm trying to do a lookup within a matrix of values, where I need to specify both a horizontal and vertical lookup criteria. From what I've found, it looks like Lookup would've be…Answered - Pending Review 17 views 5 comments 0 points Most recent by Paul Newcome Formulas and Functions
-
Duplicate column into a sheetIn Using SmartsheetHi all , Is it possible to duplicate an entire column into a sheet ? I thought it would be easy just by " copy and paste " , but it does'nt work . Do you have a solution ? Thanks in advance .
-
My filter keeps expanding all of my parent/child rows upon filterIn Using SmartsheetI want to be able to move through filters without having to collapse all every time. What am I doing wrong?
