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
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
Thank you for your response. Unfortunately, it is still showing the duration.
It doesnt seem like there are more options to choose from here.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.