-
New to SmartSheet - 2 questions on functionality
1: When using a SS form, is there a way to deny a duplicate entry based on an employee name or number? 2. Is there a way to somehow link from SS to Outlook to create calendar invites based on a date field in the SS? Thank you! Kat Gavigan
-
Validate company emails
My company has stringent risk measures that require us to not be able to send information off of our systems. We need to be able to validate company emails to ensure that 1) it's not being sent to an invalid email and 2)information is not being sent outside of the company If this already exists please let me know.
-
Dashboard Widget Auto - Update to Only Display Future Months
Is there a way for the month bar to automatically fall off the data displayed on a widget? We are tracking how many construction projects we have during the future months. We would like to see October '25 disappear from the chart without having to manually go back into the widget each month and re-select the data range. Is…
-
Change/CRAID Log Association to Project Plan Task
I'm using my Change Log as an example, but applicable to other sheets. I've manually copied the Project Plan Task ID, Project Plan Task Name, Role and Assigned To fields from my Project Plan into the Change Log. Within the Change Log I've simply made a few example requests. The relationship to any change request to the…
-
Add FORECAST Function/Formula
A Forecast function/formula would be incredibly helpful by increasing the value of the available data, and also its ability to be dynamic. My team has been looking for a solution to the lack of a Smartsheet forecast tool for years. This is the roadblock keeping us from exclusively using this program for all of our needs.
-
Copy-Paste
Please add the functionality to copy and paste rows (from reports, sheets, or anywhere in Smartsheet) with their respective formatting, formulas, and validations, just like in Excel. Right now, Smartsheet only pastes the raw values, which forces us to export to Excel to preserve formats and then re-import. Having full…
-
Conditional formatting for Sheet Summary
In some cases it's very usefull to display a sheet summary in a dashboard. It's would be highly valuable to show this in your dashboard with conditional formatting to actively trigger your end-user.
-
Question about automation to generate duration of each status
Can we get an automation to generate how long is the duration of the open, closed, and average days that each open status have been open for before a status changed? Also can we get an automated count of days that the item has been open or until the status changed to closed?
-
Can you have a bar graph widget, automatically update the source range
Hello, I was wondering if it was possible to have a bar graph widget update its source range update automatically? For example, I currently have a bar graph that shows data from April, May and June - the numbers within these do update as new data is added. When it's the end of September, the bar graph will need to show…
-
Graphs our of Report Data
In order to make it super easy to build graphs, they should also be allowed to source its data from Reports. Reports provide flexibility, filters and will normally accompany graphical data for some Dashboard audiences. Whatever data gets through the Report, it will show in the graph.