structures and creating formulas

[Sunita Pendekanti]

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 :

Time_Left

ELSE :

If Status!=Done :

WITH Time_Left = duedate - NOW() :

IF Time_Left < 0 :

Time_Left

Else :

IF Status = Done :

WITH Time_Left = duedate - NOW() :

IF Time_Left < 0 :

Done

[Stepan Kholodov (Tempo)]

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]

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.

[Sunita Pendekanti]

Admins, can you help with this please.

[Sunita Pendekanti]

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