Discussion List
Automatically add formula to new rows
I have a sheet with a formula set up to find duplicate email addresses. But, when new rows are added, the formula doesn't copy to the new row. Is there a way to make the the new row also includes the formula. Sidenote: when a new row is created, it also triggers Zapier functions so I can't just drag the formula down into…
Change color of Report headers
Is there anyway to change the color in the reports on the Catagoryies? (see arrow above). Either in the report or on a dashboard with the report.
Add 'sort order' to Filter Views
I love the Filter Views feature in Smartsheet, but it would be really useful to include Sorting options in the Filter View dialog as well. Some of my filter views require sorting by different columns, and currently it's a bit annoying have to manual sort each time I change a view.
Smartsheet Form URL Customisation
Could be more useful if there is a feature to customize the outward facing link.
Dynamic View - New Item Submission Options
I would like the ability to reload the new item submission form in a dynamic view to submit another entry. Similar to the functionality that exists within a SmartSheet Form. I get the option to show a success message, redirect them to a URL or reload for another entry. I want my users to have a dynamic view that loads…
Lock Editing Capability on a Form
Is there a way to lock a Form so that others cannot edit it?
How do I setup the Details Panel for a new submission in Dynamic View
I have selected the option to allow new submissions, but there is a note that I need to setup the Details Panel. How do I set it up to only show the required fields for a new entry and not change the other field and logic options I have already setup. When I click on new to add a new item it only shows me the fields for my…
Why can I copy and paste my if formula in rows, but I cannot convert it to a formula column?
My IF/OR formula will not let me convert to a column formula, but I can copy and paste the formula without issues. What are the reasons?
Generating a Report based off Filter Criteria
Hi All, I am attempting to generate a report off of a filter criteria in the main sheet. It is is a live document and we work off specific filter criteria's per person, but I want to generate a report based off the circled "Current Renewals" only, but when I go to to generate the report, the report takes all historical…
Count the number of occurances of text strings
I have 2 Smartsheets. Sheet 1 contains the data. Sheet 2 is a helper that I use to drive a dashboard. In sheet 1 I have course names. I don't want to have to explicitly code for each course as new courses may be added. In sheet 2, I want to return a value that is the course name in one column and in the next column return…