Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

alert export csv cell formatting issue

Lucente, Ransel Marie
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
April 11, 2024

Hello,

In opsgenie when exporting csv for alerts, it generates columns "createdAt," CreatedAtDate," UpdatedAt," and "UpdatedAtDate" fields.  However it will not list the information properly.  I tried re-formatting the cells to date or time, but it still will not list the correct info.  How to change or re-format?  

Red outline is showing both date and time in formula bar, but reformatting does not reflect it in the actual cell.

Green outline is showing how it appears without re-formatting.opsgenie alert reformatting issue.jpg

1 answer

0 votes
John M
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
April 12, 2024

Hi @Lucente, Ransel Marie ,

The CreatedAt and UpdatedAt fields in the Opsgenie export are formatted as unix time stamps. You can convert them with the following formula:

=DATE(1970, 1, 1) + (CELL_WITH_UNIX_DATE/ 86400000)

Be sure the cells with the unix dates are formatted as numbers, or the formula won't work. 

Lucente, Ransel Marie
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
April 15, 2024

I'm not following.  In my image, J5 says 21:40.0, but in the formula bar says 4/11/2024 09:21:40 AM.  How do I get the date and time into it's own cell?

 

John M
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
April 15, 2024

@Lucente, Ransel Marie the difference between the formula bar and the value shown in the cell would have to do with the formatting. We can't really advise on that since it's not related to the export, but rather the formatting of the spreadsheet editor that you're using. 

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
TAGS
AUG Leaders

Atlassian Community Events