-
Restrict Date column Based on another date column
Hello Everyone, I have two columns: Entry Date and Execution Date. I am trying to restrict the Execution Date to allow only date values that are after the date of the Entry Date value. for example: For Entry date, the value is:1/1/2023 The Execution Date: should only allow dates that are after 1/1/2023. is this possible?
-
I need to result the column's name when using a JOIN(COLLECT) or INDEX(MATCH) formula
Previously, Row 1 of my smartsheet contained the column's name. This way, I could write a JOIN(COLLECT) formula to return the column's name if certain conditions were met throughout the sheet for that row. That worked until we applied column formulas to some of the rows. Now Row 1 can't be the column's name because of the…
-
Merged: Unhiding Individual Columns
This discussion has been merged.
-
Unhiding Individual Columns
Hello, Having to unhide all columns at once can be overwhelming for new users. From a developer stand point, it's horrible. I usually have to unhide all columns to develop automations and procedures through multiple sheets and reports. Just to properly set up a lookup function can be difficult for new employees who haven't…
-
Multiple contacts in a sheet summary field
Hi, We use control center and we love using Sheet Summary field to bring in certain values from Specific Sheet (using cross-sheet reference formula) then we feed that info to column with column formula so every row will have the same info. We noticed we can't do this for Multi-Select Contact in Sheet Summary if column type…
-
Merged: New automation to copy cell content to another column (for capturing baselines)
This discussion has been merged.
-
Custom Columns in 'Sheet Summary' Report
This report is amazing and could be super useful if we have the ability to customize the column names according to our team's/organization's needs. The columns in the 'Sheet Summary' report get auto-generated and are not based on the source sheet(s). We need to be able to customize these as my team uses different legends…
-
Merged: Columns - Increase the Maximum Column from 400 to 1000
This discussion has been merged.
-
Card View and Contact List
Hi, Would it be possible to have Card View work with a Single Contact List without having to pre-define emails that would be assigned to the Column? Currently, unless an assignment is done and set up as a default contact on the column, it will not appear in Card View. Thank you
-
Allow Fuzzy Logic in Lookup Value Columns
Currently when typing in a lookup column, the list is only shortlisted to the first character(s) of the values in the drop down. It would be greatly improved to allow fuzzy logic as do forms when search via the drop down values for shortlisting. This feature should also be supported in Dynamic Views. Currently, Dynamic…
