Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

dynamically change the status base on user date interval

Hello Experts! 

I´m havingo trouble to find a way to dynamically change the status of IT Tickets based on user input.

In that project users can set a date interval and, based on closing dates I have to count if those tickets were opened on that set of dates.

 

I already created a table dDates that is a calendar formula with min and max dates of my tickets table

 

How to to this?

 

Thanks a lot!

2 Replies

  • Anonymous 

    Can you share some sample data with the desired output to have a clear understanding of your question? Mention whether you want a calculated column or measure
    You can save your files in OneDrive, Google Drive, or any other cloud sharing platforms and share the link here.


    • Anonymous's avatar
      Anonymous
      Not applicable