-
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…
-
Several tests on the Same Object need help with Report and Layout
I have an experiment where I test object a, b, c, d. The variables (columns) will be height, weight, fill with fluid etc. however I might have changes for the test objects and re-run the experiment where I poke a hole in (a) and therefore need it to be tested again. How do I create a report that shows all tests a-d and…