Get the status of a jira issue

[Ramkumar A]

How to get the status of the single jira issue using the key or any other unique field?

[Karolina Wons_SaaSJet]

Hello @Ramkumar A 

The Jira status is displayed above each your Jira issue on the dashboard.

Can you clarify what do you mean?

[Ramkumar A]

I am using google sheet to integrate and pull JIRA tickets and its status using JIRA() function.

JIRA issue id (key) is already present in the googlesheet.

[Nic Brough -Adaptavist-]

Whatever your "pull" is, it should simply be asking Jira for the Status of the issue (most functions in Jira include it in the response by default - when you look at an issue on-screen, it's shown there, when you ask for an Issue over the REST API, it's included unless you deliberately exclude it, the default columns on the issue navigator which you can export to CSV include status, and so on)