Hello everyone!
I have 3 fields:
1. Date field
2. Formula field that will show a date based on the date field
3. Type of issue field
What I want to accomplish is this: the formula field should only show the date IF a certain type of issue in the 'Issue field' is chosen.
How do I accomplish this using a formula?
+18Try
IF({Issue field} = "Type 1" , {Date})@TheTimeSavingCo Thanks for your reply.
Can you help me with this similar formula aswell?
So in the same formula field, I want to look at the other issue (Issue B) too. If Issue B is chosen I want to know whether or not the date for issue B is within 90 days. If it is, I want to have shown the earliest date in that 90 day range.
So fx. if the deadline is the 1/5/23, I want to have shown the date 31/1/23 since that's the first date within that 90 day range.
Is that possible?
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
