-
Card View: New Cards Disappear Due to Hirearchy, Need Advice
We are managing a large multi-project delivery roll up board, where the preferred view is Card View. We would also like to start adding, removing and editing as needed in Card View. The challenge we face is this: Projects are the top level row, with child / gchild rows as either deliverables or tasks. This board is highly…
-
Sorting from Filtered tasks & Auto-Alert with properly sequenced task list to individual users
Hello, 2 Questions: 1) When I have filtered task lists and I want to sort sequentially; the sort option is disabled. Is there any way to sort tasks on filtered tasks list? (see below). I tried to sort by adding WBS column with format of 1, 1.1, 1.1.1, etc with various levels/hierarchy; however, that did not work either.…
-
How to create a dashboard of KPI from sheets and reports
Hi - I am trying to create a monthly, quarterly and annual view of a KPI Dashboard to visually show the information I have in a Sheet. I have checkboxes to tell me which Dashboard the metric will need to be in. I know I need to likely make some reports in order to get the widgets to work correctly but I am having trouble…
-
I need to link data from newly inserted row column C, E and F from SOURCE sheet to DESTINATION sheet
I can link data from existing rows (from source sheet) but if NEW ROW gets inserted I need a solution that can link data from the particular columns in that row to destination sheet.
-
Adding Callout point to a graph in SmartSheet
How do you add callout points to a graph in SmartSheet? I'm looking at monthly volume over a 3 year period. I would like to notate when new major accounts were onboarded. Below is an example in excel of what I am trying to accomplish. corresponded with increased volume.
-
Smartsheet Dashboard Performance Issue
The New Smartsheet Dashboard is behaving very very slow. Alternatively, I am shifting to the Classic version to update dashboard changes or any cosmetic changes. Is there any alternative options to fix this performance issue OR its a part of new product enhancements and can expect any bug fix in future. I can a message…
-
2-Step Row Removal
In order to avoid accidental triggers of a row removal automation, I'm trying to set up a 2-Step process. Essentially I want someone to select "Remove" from the status dropdown & check a box next to the dropdown in order to trigger the automation. Picture below is of the automation logic, which currently does not work. If…
-
Limit Sheet Rows Available or Limit Form Submissions
Hi i'm trying to manage an event using SmartSheet. I have 4 sessions and each session can only have up to 30 registrants per session. What i currently have is a single form with all users information included. Users will come into this form, and in a single column, I have the options for the 4 sessions. In this column,…
-
💭 Who are the women that inspire you in work and in life?
Join us in celebrating International Women's Day! Share a photo or a few words about the women who inspire you in work and in life.
-
NETWORKDAYS formula give different answers with same inputs
If I use NETWORKDAYS formula in two cases mentioned below, I get different answers. Date_T column has dates in text format (formulas mentioned in Formulas_T column). Networkdays formula gives 22. =NETWORKDAYS(DATE(VALUE(MID([Date_T]1, 7, 2)), VALUE(MID([Date_T]1, 4, 2)), VALUE(LEFT([Date_T]1, 2))),…
