I have a form and tabular view corresponding to it.
In that tabular view I have two columns 1. Due Date 2.status.
I want the status values to populate based on the dates in the tabular view without any manual activity.
Ex: Due dare: 12th Jult 2021
If Current date is 1st July want the status like available
If Current date is 10th July then approaching sla else due
You can set up a status field to be a formula field with an expression something like this
IF(NOW()-[entry.dueDate]<0, IF([entry.dueDate]-NOW()< 172800000, "Approaching SLA", "DUE"), "Available")
Assuming the field to store the Due Date is named "dueDate"
"Approaching SLA" status will be shown when now and due date is smaller than 2 days (in milliseconds it is 172800000 and that is what I am comparing to here)
Hello Community! Quick disclaimer: We are running a contest on Community (The Atlympics!) from July 23rd - August 8th of 2021. If you are interested in participating in this contest (prizes! ...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events