Help

Formula field should only display date IF (help)

Topic Labels: Formulas
866 2
cancel
Showing results for 
Search instead for 
Did you mean: 
plyske
7 - App Architect
7 - App Architect

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? 

2 Replies 2

Try

IF({Issue field} = "Type 1" , {Date})
plyske
7 - App Architect
7 - App Architect

@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?