Best Of
Re: No se puede crear la tabla Pivot
Hola B Chavez,
Eso me paso y no pude crearla tampoco. Le envie esa pregunta a la experta en Smartsheet y no me ha respondido. Estoy por contactar al servico de ayuda o help desk. En mi caso, espero que no sea una limitacion de funciones o subscriptcion (que no creo) pero no descarto nada.
Disculpe que no sea de mucha ayuda.
harocha
Re: "Boolean Expected" Error
It sounds like you are attempting to either check or not check a box based on the content of another sheet. The way your formula is structured, you will be returning the value of {GenFertCalc}. Unless this value is 1 or 0, you will get the boolean error.
Can you give a description of what you are attempting to accomplish, or even better, post a screenshot of the source and target sheets?
Edit:
Taking a stab at it before you respond… is this what you are trying to do?
=IF(COUNTIFS({Client Name}, [Client Name]@row, {Tones}, "Granular Fertilizer (Tone)") > 0, 1, 0)
Carson Penticuff
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
PM_Reeves
Re: Count # of cells approaching a date for sheet summary
@Isis Taylor, that worked for me too! Thank you so much!
rbattista
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!
Brian Wilson DC
Re: Introduce yourself & get to know your peers!
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!
Yulichka
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!!!!!
Jen6122
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.
Jen6122
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.
Jen6122