How can I do a check on data that is "filtered by connector - not synced" to omit data from formula
Answers
-
Hello @Dom Carissimi,
After some investigation, I don't think there would be a method of excluding JIRA items based on an API Tag, as these are system values, rather than cell values.
If there are any differences between the JIRA Data and the manual input Cell data, you may be able to create a Formula around this E.G If JIRA Adds an ID number to JIRA data rows, you could us ISBLANK in your Formula when referencing the Column.
Are you able to confirm if JIRA imports data only on JIRA Rows, or does it apply data to all rows with no difference in cell data between JIRA and Smartsheet?
Regards
Sean
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.9K Get Help
- 410 Global Discussions
- 219 Industry Talk
- 457 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!