Jan 30, 2023 05:42 AM
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?
Jan 30, 2023 06:03 AM
Jan 30, 2023 09:06 AM
@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?