-
More Gantt Timeline Display Options
Due to limited screen space, I find the available Timeline Display options either far too dense to be useful, or too expansive. I propose: more Zoom settings. my issue is really that the zoom settings correspond to the heading incremements. my usability issue would be mostly resolved with more zoom level granularity. more…
-
Parent Rows in Report
Hello, I have a made a current user report which shows only tasks where the current user needs to update. However I need the parent rows to show above the current user which may not be assigned to the same user. Is there any way to show parent rows in a report if there is filters that are applied which stop from parent…
-
Formula does not appear to be working
Okay, first, here is my formula: =IF([Release Name]@row = "", "", IF(COUNT(ANCESTORS()) = 0, 1)) It is in the far right (second image) in the column named Is Parent, which is a checkbox. I only noticed this issue as a result of checking on these release numbers that are a variation of the same number with letters as a…
-
Potential IF/AND with multiple criteria (each listed multiple times)
Okay, let's start out by saying I am so stuck I have no clue on how to create this formula! LOL Okay the formulas will be added to the PA - CAPA List sheet. The Training Report is the data source. This is just a small sample of my data (there are about 25K rows). In the sample on the Training Report you can see the names…
-
Expand "Web Content" widget sources list
Hello, There are a variety of video platforms that are out there that we are unable to embed into our dashboards, which limits the functionality significantly. Are there any intentions to expand the list of permitted sources to websites like DeepHow and LinkedIn Learning? Thanks
-
Formula for quarter based on finish date
I want to create a formula that will auto-populate the Quarter column with Q1, Q2, Q3, or Q4 based on the date entered in the "Finish Date" column. For instance, if the "Finish Date" is 4/15/2021, I want the Quarter to be "Q2".
-
Hyperlink Target a New Tab
I have created a form that contains a fair number of hyperlinks. These all take users to a site outside of Smartsheet. Is there a way for me to direct those hyperlinks to open up in a new window/tab instead of the same one?
-
Can a report contain a query string or prompt?
I'm looking for a way for a user running a report to input a query response that is then used as the filter in a report. For example, a report lists all projects assigned to a variety of sponsors. Can I somehow create a prompt so that each time the report is run that the end user gets a prompt for which sponsor they'd like…
-
Automation at the workspace level (Link sheets to workspace automation)
I would like a way to setup one automation that is used on all sheets within a workspace. All of the sheets in the workspace are the same and are used to track information for different employees. Currently I need to change the approval process to remove one group. That group will now receive a notification only. In order…
-
Adding Names from Sheet 1 to Sheet 2 with Counter update and handling duplicates
Good afternoon, I'm trying to achieve the following without success: I have Sheet 1 that as forms are submitted a Names column is filled. I have Sheet 2 with a Names and Counter columns When a new submission occurs, I would like to get that name from Sheet 1 and add it to the Name column in Sheet 2 if it doesn't exist…
