-
Column and Row Transpose
To whom it may concern, It would be very helpful to have a simple feature to View Columns as rows and vice versa within a sheet. A simple setting to allow the column headers to appear as rows and row information to appear on top. With the associated cell data still in the correct position. Please and thank you. Kindly, Dj
-
Add "Latest Comment Column" for SmartsheetGov users
Right now, I'm able to see comments added in sheet form and in a form generated from Request for Update workflow. What I would like to have added to the SmartsheetGov side is the Latest Comment Column so that comments made on sheets can be displayed on reports and/or dashboards. Having this feature for SmartsheetGov users…
-
Auto Increment as Formula is copied to the right
I have a formula that is referencing another sheet, and I would like a way to copy this formula in column "Rating 1" =IFERROR(INDEX({Rating_Avg_Selection}, 2), "No Data") in the same row to the right (next column), and reference the next number within the formula, which will point to the correct row where the data resides.…
-
Merged: Conditional Formatting for Duplicates
This discussion has been merged.
-
If Then Help
If a cell in Column A (titled Job) equals Marketing (from drop down in Column A), then adjacent cell in Column B (titled Responsible) equals Susan (name from contact list). I want someone to choose from a drop down in Column A, then based on their choice a particular person receives an email. Column A is set for multiple…
-
Where can I find column ID in smartsheet?
For row, this is very easy. But it's not clear for column. Where Сolumn ID?
-
Separate Text/Number Column Type
As the owner of a data sheet, my data cleansing would be significantly reduced if the column property could be set as a text only or a number only. When I have a column in which I would like a number to be added, some people put "TBD" which messes up my connected dashboarding calculations. Can we please have the option to…
-
Formula not working in some cells of column
I ran into an odd situation where the formula I am using is not working in some cells. I tried using this as a column formula (How I would prefer). I also tried it as a cell formula. But I have random rows where the formula simply refuses to work. This is the formula in question. It should fill in the Additional assignment…
-
Prevent Report Column Name from Printing... (same as is available for row #'s)
I often use columns for multiple purposes and the main column name is not always applicable. I can get the appropriate rows to show and even designate alternative column names in a row. I can even make this row show up where needed in the report. However, when the report is printed to PDF the column names cannot be toggled…
-
Best Practice for Multiple Sheets with Column Formulas
On my Smartsheet I have multiple sheets. Requests come in on the Request sheet, then move to an Approved, Hold, or Rejected sheet. I'm wondering if some of the column formula's I have should be removed from the all but the Request sheet. Those formula's are meant to provide guidance on what action should occur with a…