Notifications
Clear all
Topic starter
Good Morning, I am struggling with creating a Sparkline Chart, which I am doing for my uni essay. I am trying to insert the formula =IF('DASHBOARD!A6="","",’DASHBOARD!A6), however whenever I insert it, it says there's a problem with this formula, can someone please help me?
I have also tried without the apostrophes, but it doesn’t work.
when I press enter, it gives me the Auto Sum sign instead. Instead of giving me the name of the state ( Birmingham), it gives me this: Σ
Posted : 14/05/2021 7:39 am
Hi Youri
I suspect it is the single quotes in your formula.
=IF('DASHBOARD!A6="","",’DASHBOARD!A6)
If not, then please attach a sample for us to have a look.
Sunny
Posted : 14/05/2021 10:50 am
