Best Of
Re: How to center data in columns on report for dashboard
Hi @AmandaB23
As far as I know you're unable to format columns in a report.
You need to make the alignment changes in the Sheet, but be aware that Primary column has ideas all of its own, just to let you know that is is The Primary Column

Re: Count # of cells approaching a date for sheet summary
@Isis Taylor, that worked for me too! Thank you so much!

Re: countifs help
@tracyashton I'm glad that it all worked out! If you ever need anything feel free to ask! Have a wonderful week!

Re: Introduce yourself & get to know your peers!
@NickSakersΒ ,
Howdy,
I am #5 on your list and want to say, "Hello" right back at ya :).
I currently live in Madison, WI and I absolutely love Ft. Lauderdale so lucky you!
We have an amazing community here full of people who are always willing to share tips & tricks to help at least one other person from the ginormous amount of time they spent before they discovered a shortcut that resulted if not only reduced time but still the same accurate results.
So, welcome and feel free to ask all of the questions that you might have. There is always someone up and willing to help here.
Thank you & Happy New Year! :)
P.S. I forgot to include a picture the first time around in my post.
CHEERS!

Happy yo be here
A co-worker of mine suggested I attempt to become a part of this groupβ¦. and I am very happy that he did. Seems to be tons of additional infirmation that will help me optimize my Smart Sheet use. Glad to be a part of. Thanks!!!!!

Re: Introduce yourself & get to know your peers!
Hi i am Jennifer Farrington. I work as a Project manager at a telcom company and Smart Sheet has become our new go to for PMing to our best ability. I love it.

Re: Introduce yourself & get to know your peers!
Hi there, My name is Jen. I work in the telecommunications field. I have been working in Smart Sheet for the past 3 months. Still a lot to learn I am sure, but I am glad to have found this outlet that will no doubt assist during those times I may get stuck. I feel surrounded by a wealth of knowledge with all of you : ). Look forward to working with you all.

Re: Hello! I am trying to make a graph with these dates!
I was not able to put it in a reference sheet but I did figure out the formula I needed and just put it below!
=COUNTIFS([Start Date]:[Start Date], AND(@cell >= DATE (2021, 1, 1), @cell <= DATE(2022, 12, 31)))

Re: Nominate Peak Humans & get a badge!
I nominate @EEK for the Peak Human Badge. She breathes Smartsheet. Even on her days off, I can call her and she will drop what she is doing to help me with a Smartsheet question. And I don't mean just for a 5 min conversation. We are talking hours on a Teams call. She doesn't look the slightest bit annoyed by it. She loves Smartsheet! You can tell.

Re: Variance on time or behind schedule collumn
Hello @Joechaptaylor. Try something like:
=if(Variance@row="","",if(Variance@row>=0,"On Track","Behind Schedule"))
