Forum Discussion

Icon for Impactful Individual rank

Impactful Individual

7 years ago

Solved

error for new coloumn formula

Hi Team,

i am facing some error, let me know if anyone can help, below is the error and my table

v-juanli-msft
7 years ago
Hi vjnvinod

Create a column like

column = IF([event_date]=BLANK(),"upcoming", IF([event_date]<DATE(YEAR(today()),MONTH(today()),1),"YTD", FORMAT([event_date],"mmm-yyy")))

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

3 Replies

v-juanli-msft
Community Support
7 years ago
Hi vjnvinod

What is the "current month","previous month"?

For example, when event date=2018/11/15, is this date equal to "previous month" or not?

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- vjnvinod
  Impactful Individual
  7 years ago
  v-juanli-msft
  
  Current month is basically June 2019 and anything prior to June 2019 is previous month
  - v-juanli-msft
    Community Support
    7 years ago
    Hi vjnvinod
    
    Create a column like
    
    column = IF([event_date]=BLANK(),"upcoming", IF([event_date]<DATE(YEAR(today()),MONTH(today()),1),"YTD", FORMAT([event_date],"mmm-yyy")))
    
    Best Regards
    Maggie
    
    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Related content