-
"Rows deleted" no longer a trigger option. How can I track deletions?
When setting up a workflow to alert someone, I no longer see the trigger option of "when rows are deleted". How can I receive notification of this action?
-
Duplicate Workflow Condition Paths Option
Currently when building a workflow, if you need to create more than one condition path but only 1 or two criteria out of several are different in each condition path, you have to recreate each condition path from scratch. This can get very time consuming if you need multiple condition paths. Could a function be added on…
-
COUNTIF or SUMIF Formula in Report Summaries
Currently the summary count function only supports basic formulas. It would be great to be able to have the ability to use a COUNTIF or SUMIF Formula in report summaries. Specifically to count only the checked boxes. This feature would be nice to roll up metric data quickly and avoid the need to create a separate metric…
-
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…