-
Add Parent Link to Smart sheet/JIRA connector
Currently, the Smartsheet/Jira Connector is not populating the Parent Link, as Jira moved all Epic Link into Parent Link. With Parent Link, this allows user to be able to calculate the percentage of the completion of the Epic, so anything and everything can fit under it. There is a bug or no support as smartsheet should be…
-
How do I automate a cross check between two Employee Name columns that are formatted differently?
I've inherited a large set of sheets that were set up to pull in employee info based on an employee ID number input via form. There is an INDEX:MATCH to display the employee's name, supervisor, position, etc. from an agency roster based on the ID number. Because some employees mistype their ID number, the wrong info (or…
-
Schedule underlying data downloads in RM
We have our budgets in Smartsheet and our Project time tracking is done in RM. We need to pull Smartsheet budget data and RM data into PowerBI to create dashboards which integrate with other platform data. We use Powerbi Smartsheet connector which is great but the only way to do the same for RM is to manually download the…
-
Automation Email Alert Issue - Grouping Notifications with Unique Subjects
Hi everyone, I've been experiencing an issue with an automation setup and was hoping to get some insights or solutions from the community. Problem When I configure automation to send an email alert to a contact after a trigger change, the system groups email notifications together even though each has a unique value in the…
-
Retrieving parts of a text fields
Hi there, I have a project identifier column that includes a project code (111-AAA) and project name (client name). Ex: 123-ABC Disney Corp I would like to separate the Project Code and Project Name into 2 Columns, which will result in me having 3 columns Project Identifier, Project Code and Project Name. For the 'Project…
-
#Invalid Data Type
I have a successful formula in a sheet summary that is as follows =AVG(COLLECT([Prototype Lead Time (PO DATE and Ship Date)]:[Prototype Lead Time (PO DATE and Ship Date)], [Target Ship Date]:[Target Ship Date], IFERROR(YEAR(@cell), 0) = 2020, [Target Ship Date]:[Target Ship Date], IFERROR(MONTH(@cell), 0) = 1, [New/ Add'l/…
-
Why do my Index Match fields not show the results on Reports?
I have some reports from a sheet that populates a few fields from an index/match formula. On my report, the data doesn't come through. It shows #INVALID REF even though the data is correct on the Smartsheet. Also, it seems like the report isn't updating when those fields on the Smartsheet are updated. I have some other…
-
How to place a sheet link on a report
This discussion was created from comments split from: How to place a Sheet Link in a Report.
-
How to display unique dates from a sheet (source) to another sheet
Hi, I tried searching on this topic, and found a formula that worked for someone else. =IFERROR(INDEX(DISTINCT(COLLECT({Column 1}, {Column 1}, AND(ISDATE(@cell), @cell >= TODAY(-45)))), [Row #]@row), "") While I am trying to figure how to use it for my needs. My sheet has column name "Visit_Date" with listing of dates My…
-
check column against another sheet of applicants
This discussion was created from comments split from: Using an OR in COLLECT.