-
Change Sheet Summary Field Name from Sheet Summary Report
We are working on a client project. We have 15-20 summary fields and we want to create 5-6 more. The problem is if we add exact names of 5-6 fields, it will take hours to finish it. What we want is to name those fields as 1,2,3,4,5,6 and save it quickly. After this activity, we can. create a sheet summary report and change…
-
Create a fiscal year formula
I include fiscal year on most of my sheets. Our fiscal year starts July 1, so I write a formula such as FY = if(Month(date)<7, Year(date), Year(date)+1). Would it be possible to create a FY formula in Smartsheet that returns the FY when provided a date and the FY start? FY(date,FYstart) as FY( mm/dd/yyyy, fymm/fydd )? Or,…
-
Allow Gantt view to use Date columns with Column Formulas for Start/End
I'm kind of flabbergasted that this is not currently possible in a Sheet, and I'm struggling to explain to my users why. It is already possible to populate a Date column with a Column Formula and then convert it to a Cell Formula, and then use that column as the Start/End for Gantt view / Project Settings, so the issue is…
-
Radio Button Mapping and Syncing to Docusign Document Builder
Add radio button mapping and syncing to the Docusign integration.
-
Increase the limit within Contact List column
Currently there is a limit of 20 contacts within the Contact List column, which is not sufficient for our needs. It would be great to either increase the maximum to a significantly higher number, or removing the limit whatsoever.
-
Enable Hourly, Daily, and Weekly triggers when there is custom field in the notification box
Hi Product Management Team: Goal: Send a notification once per day to an assigned individual that includes all the work items (tasks) they've been assigned. Customize the notification so it includes the assignee's name. Problem: When I insert a custom field in the notification customization box like this: Hello {{Assigned…
-
Admin Center User Auto-Save Default setting Control
When a new account is created, auto-save is automatically turned on. In our company, we would like to disable auto-save by default. However, there is no way to set the default setting for this in the Admin Center. Many of our users have many Tabs open and use multi-screens. We want to avoid them accidentally overwriting…
-
AI-step in workflows
Imagine you have a sheet with three columns. E.g. Notes, requirement and rationale. The notes field has no constrains, the requirement column is intended to contain the requirement extracted from the notes column and the rationale the motivation for the requrieement. For this kind of scenario it would be useful to use AI…
-
Checklist column
In MS365 planner one can add checklist items to a task. In smartsheet it would have been nice with either a new column type for checklist or more editing possibilities (rich text formatting ) for the text fields. This way one could make checklists for allocations. That is, for a row with a task spanning several weeks, one…
-
Automation on Sheet Summary Fields
Workflow/automation based on sheet summary fields. One scenario - count of all cells, send a warning if the sheet is close to max. (Do not want helper column as that increases the count.)