structures and creating formulas

Sunita Pendekanti September 27, 2023

1. This below query is correct and showing green, however it is not seeing the status field for example,  when the "due date" is past and the status is done, it is supposed to return Done, it is returning the days instead. Can you help pls

 

/* Displays how much time is left before the issue is due. */
IF duedate : WITH Time_Left = duedate - NOW() :
IF Time_Left > 0 :
ELSE :
If Status!=Done :
WITH Time_Left = duedate - NOW() :
IF Time_Left < 0 :
Else :
IF Status = Done :
WITH Time_Left = duedate - NOW() :
IF Time_Left < 0 :

2 answers

0 votes
Stepan Kholodov _Tempo_
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
September 29, 2023

Hello @Sunita Pendekanti 

Please try this formula instead:

with Time_left = duedate - NOW():

if duedate:

if Time_Left > 0 : Time_Left else
if Time_Left < 0 and status != "Done" : Time_Left else
if Time_Left < 0 and status = "Done" : "Done"

it should:
- return how much time left if Due Date isn't past yet;
- if Due Date is past and Status isn't 'Done' - to return how much time left;
- if Due Date is past and status is 'Done' - to return 'Done'.

I hope this helps. If you need further assistance, please reach out to us directly at our support portal.

Best regards,
Stepan Kholodov
Tempo


Sunita Pendekanti September 29, 2023

Hi @Stepan Kholodov _Tempo_ 

 

Thank you for your response. Unfortunately, it is still showing the duration.

It doesnt seem like there are more options to choose from here.

 

image.png

0 votes
Sunita Pendekanti September 27, 2023

Admins, can you help with this please.

Sunita Pendekanti September 28, 2023

@Davo I saw you are the team memeber, can you please help if possible.

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events