-
Control Center-Generated Report Issue
Hi - curious if anyone else has ever come across this - not sure if it's an issue or if it's something in the configuration that I am doing wrong. We have a control center solution that uses Dynamic Report scope to add the reports for newly provisioned items into a blueprint-level summary report. We have them grouped by…
-
Merged: Dynamic drop down lists on Forms/Sheets
This discussion has been merged.
-
Dynamic drop downs- possible in smartsheets?
My boss recently challenged me to see if I could add some logic to our project plan smartsheet templates where if a user entered in an Assigned To column can dynamically narrow the values available in a Role column to show only the roles the person selected in the Assigned To column is eligible for. For example, let's say…
-
Column level permissions
Since there aren't column level permissions, I tried Dynamic view, which would work great if we could utilize proofing with Dynamic View, which is not possible. I have columns a specific group of users should NOT be able to edit on my sheet. However , I utilize proofs. Does anyone have a creative solution to not allow the…
-
Dynamic scope report in Control Center not pulling the files
Dear All, I am struggling to figure out why a dynami report I set up in Control Center doesnt pull in the files. It is stubborn to keep only 1 file, instead of the 30 I think it should. Is there a setting in CC that I missed? I followed the instructions. First I created a report in a designated workspace, added it to the…
-
Merged: Enhance Dynamic View with Grid, Calendar, Board, Gantt, and Card Views
This discussion has been merged.
-
Sum cells based on multiple criteria with a timeframe requirement
I am working on trying to sum the time I spend across all my projects and want to sum different columns but only when they meet different criteria. Every formula I work through doesn't seems to work. I want to sum the Duration of Meeting IF the start date of a subject is within 5 days of the date in the green box that I…
-
Dynamic Dropdown List on Form
I'm working on creating a form for travel document submission. They have to submit travel documents by specific trip number. I want to make the drop down list for trip numbers dependent on the division the select. ie They select Division A, they only get a list of trip numbers for Division A. Additionally I want to limit…
-
Dynamic Forms (PDF Generator & Sizing)
It would be absolutely incredible if you could have a form that you also map to a PDF builder which dynamically resizes the answer boxes based on the length of answer on the form. At present you have to make the dummy PDF and resize answer boxes to be the max possible length, else the text overflows etc. - which is not…
-
Dynamic Column Reference
Hi! Lets say I have a basic formula like this in a "budget" column: =SUM([Week 1]@row:[Week 10]@row) And I also have a cell in a helper column that includes this formula: =WEEKNUMBER(TODAY()) Is there a way of [Week 10] changing to [Week X] based on the number in the week number cell? I have a column for every week of the…