Upcoming Holiday on Dashboard

Ozu

Hello All,

I like to display the upcoming public holidays on my dashboard a week before so I created a formula to display the upcoming holiday for the Smartsheet dashboard a week before the holiday but I am getting an error #INCORRECT ARGUMENT

Can anyone please suggest where I am making a mistake?

Paul Newcome

Try this instead:

=JOIN(COLLECT({Holidays Range 1}, {Holidays Range 1}, AND(@cell>= TODAY(), @cell<= TODAY(7))), CHAR(10))

Paul Newcome

Try this instead:

=JOIN(COLLECT({Holidays Range 1}, {Holidays Range 1}, AND(@cell>= TODAY(), @cell<= TODAY(7))), CHAR(10))

Ozu

Hello @Paul Newcome,

Yes, the formula is working, getting the correct answer.

Thanks