Forum Discussion

Pezir's avatar
Pezir
Frequent Visitor
7 years ago

Create column, Display Data from another column if current month, otherwise blank

Hi!   I try to explain this. :manvery-happy: I would like to create a new column which shows data from another column (sales) IF that sale has happened in current month OTHERWISE blank cell. ...
Need Help
venug20's avatar
venug20
Resolver I
7 years ago

Pezir

 

i forgot to provide SM Formula...

 

SM = DATE(YEAR(TODAY()), MONTH(TODAY()), 1)

Pezir's avatar
Pezir
Frequent Visitor
7 years ago

Thank you venug20 I will try this later.