-
Change in Report Summary Function
Was there a recent change to the summaries function in a report. In my example below the summary count would only calculate if the box was checked. For example the adj approved count for this section would be 1 and the count for adj rejected would be 4, instead of it counting the total rows for both. Is there a way to…
-
Calendar View is Defaulting to Created Date and not current month
Hello I have an Events sheet that only has one date in the sheet. When we go to open the calendar view, it opens to the month the form was created and not the current month. I can't seem to change this. Is there a setting I am missing?
-
Department Helper Column Rollup Multi Select
The goal here is to create a helper column that with a formula will grab the department information from each task row, and then roll that up into the parent phase and project rows. However sometimes there is a department in the parent rows that are not in the task rows. So I need to be able to grab information from not…
-
Kanban board setup
We started moving towards using Kanban boards and have set up lanes vertically. But how do we add horizontal lanes to support a true Kanban board? Also add a yes vote to setting WIP limits.
-
How can I change the date format in Dynamic View?
I have all my Smartsheet sheets with the date format like DD/MMM/YYYY but when I create the Dynamic Views the date format like DD/MM/YY. Someone can help me correct this to reflect exactly the same format as my sheets? My sheet My Dynamic View
-
Template with Dynamic view and Control Center
One of our templates relies on dyanmic view. Will the settings for Dynamic View stay in place when new project is created? All projects are created using Control Center. I've already searched in the Community, looked a articles, and learning.
-
2 views from the same datasets
I'm working within gov trying to create 2 different views from the same datasets. I have a sheet for a given project that includes the staff (in rows) and the number of hours to work on that project for a given week (in columns). I have multiple sheets of this information (for multiple projects). The project view…
-
Parent Row Schedule Health functionality
Hello, I have a column formula that is returning random results, mostly on parent rows. The formula is: =IF(Status@row = "Complete", "Green", IF(OR(Status@row = "In Progress", Status@row = "Not Started", Status@row = "On Hold"), IF(ISBLANK([Target End Date]@row), "Red", IF([Target End Date]@row < TODAY(), "Red", IF([Target…
-
User Permission Granularity: Group Admins restricted to specific groups
We'd like to be able to control administration of our user visibility at the Group level. Today it is our understanding that a Group Admin can see into all Groups and not just those where they are a member.
-
Add to INDEX formula to account for blank cells?
I have a mapped column that displays a Contact based on what's inputted in another cell. E.g. Slim J = Slim Julian. Here's the formula: =INDEX({PD - NetSuite Name Mapping USE Range 1}, MATCH([PDS Selected]@row, {Formstack Name}, 0)) However, if the cell is blank, it just assigns the first Contact alphabetically, even…