-
Checklist Summary Reports
Id like to summarize status for a list of users involved on multiple project checklist. The dashboard function tells me I can only use numerical data in reports/widgets. Is there something I am missing? I want to provide a quick glance at overall status of multiple checklists.
-
Gantt timeline
Hi! I'm finding the Gantt timeline zoom options quite restrictive/extreme. Does anyone know whether there is way to either: - Zoom the timeline more variable than the standard extreme settings - Show 12-months' worth of timeline Thank you! Steve
-
Autofill based on the new entry in another sheet
I run constantly to the same problem and decided to shout out for help. Basically my problem can be defined as cross sheets conditional autofill. My case: Sheet 1 (offers) - sales people add data about new offers with the web form (that's OK) Sheet 2 (orders) - I need to bring data from the sheet 1, if offer's status is…
-
Filters in charts
I have a huge data set and that need to be filtered owner-wise in my bar/pie chart. However, I do not see any filter option available. Please help me if someone is aware of this.
-
Creating a Form with Row information
I am looking to create a form that populates information into specific rows, not based on columns. I see a few discussions from several years ago, but nothing recently to see if this is doable. Anyone know if this can be done?
-
Copying cards and substasks
Is it possible to copy cards and subtasks in the card view and have the new lines generated in grid view? Make sense? Im trying to copy all subtasks for a new card but just have the user update the main task name. Thanks
-
Auto format drop down menu
Hello everyone, I am trying to set an auto format for drop down menu to give select options from another column's drop down menu. Does anyone know how I can accomplish this? Example: If Assignment is Compliance give me the 5 specific compliance options from a list of 20 on another column. Thanks in advance,
-
Sharing Question -
A workspace was shared with me, and I was made an editor who can share. For a specific SmartSheet in a subfolder underneath that workspace - how do I request to the owner that I want to be an admin of that SmartSheet in order to set up conditional formatting, send automatic alerts, etc.? I do not see any option of making a…
-
SumIfs Current Month
Hello, I am trying to sum hours noted in the children of a row (Total Hours per Project) if the current month is noted in another cell (Week Ending With). Here is what I have: =SUMIFS(CHILDREN([Total Hours per Project]1, [Week Ending With]:[Week Ending With], MONTH(@cell) = MONTH(TODAY())) and I continue to receive a…
-
Question about embedded webform and filtered sheet in confluence
Dear all, I did some research about the following topic but somehow got stucked and every helping hand is appreciated. What is the current status: Currently we are using smartsheet (lets call it "project_overview") to keep track on all our projects. After a few years this list is quite big (around 700 rows) so we are…
