-
Cross sheet functioning column formulas working perfectly...except for two rows?
Problem Summary: I have a series of formulas and cross sheet references which grab display data that meet certain conditions. They are working consistently across usage…except for two rows? For data sensitivity, I'll only be including the date fields out of the display data, but the same error applies to all final display…
-
List of Automations that include a Specific Column
We have multiple automated workflows that may utilize a single column. Currently, the only way to know if a column is used in a workflow is either in the workflow builder view or when you attempt to delete a column used in a workflow. It would be awesome to see a list of all automated workflows that are currently utilizing…
-
Best practice to apply formula to columns
Hey y'all. I often catch myself stuck on applying a formula to a whole column. Is there a best practice or more effective way to apply formulas?
-
Export Column Properties
I would like to be able to export the column properties of a sheet. It would be incredibly beneficial to be able to export the extensive structure: Column Name Column Type Allow multiple values per cell Restrict to list values only Values Restrict to dates only Allow multiples contacts per cell Restrict to list values only…
-
Export Column Properties
Is there a way to export the column properties of a sheet ? It would be incredibly beneficial to be able to export the structure: Column Name Column Type Allow multiple values per cell Restrict to list values only Values Restrict to dates only Allow multiples contacts per cell Restrict to list values only Add contacts…
-
Sheet Properties / Metadata - Column Count
Rows are numbered but columns are not. There should be sheet metadata available thru File / Properties that tells the user how many columns are in the sheet. This would be helpful for solution developers to know if they're approaching the 400-column limit without the tedious and error-prone task of counting them manually.…
-
Filter Columns as part of Filtering Options (not manually hide/unhide)
I would like to be able to use the "filters" feature at the top of the sheet, to filter columns, ie: "automatically hide/unhide columns", just like is available for the row filters. We use this tool as a customer facing tool and I don't want to have to manually hide/unhide the "helper" and administrative columns. By being…
-
Merged: Column Descriptions in Reports
This discussion has been merged.
-
Preserve Email Format When PopulatingMulti-Contact Columns
Description: In Smartsheet, when a Contact column (that allows multiple contacts per cell) is populated using a cell reference containing an email address, the value displayed in the target cell is automatically converted into a display name. Problem: This behavior causes a disparity between the input and output data when…
-
Fix #INVALID COLUMN VALUE error when using Index Match in a different column type than source sheet
Hello! I am curious if there is a solve to the #INVALID COLUMN VALUE error I get when trying to pull a value from another sheet using Index Match, and both the source sheet and current sheet have different column types. I am currently using the following formula: =IFERROR(INDEX({OChM - Intake - Intake Meeting Date},…