We have a Control Center solution and forms that are tied to RAID logs and more. We have no way on a FORM to automate a project name or ID We would love (like on Card View) for a Column Formula to show static information on the form that pulls from the sheet. OR the option to pull Sheet summary data to the form. This would…
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?
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…
This discussion has been merged.
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…
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…
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…
Hi there. Two people at my current client are color blind. When using the Red/Yellow/Green/Gray "Symbol" set in a sheet, I learned all the colors in this symbol set appear as grey to them: Changing the colors (darker reds/maroons and 'golder' yellows work to provide variation), or adding a letter to the center of the…