Best Of
Re: No se puede crear la tabla Pivot
La acción de "Create" configura correctamente la tabla Pivot para que se ejecute con la frecuencia establecida. Sin embargo, si no deseas esperar a que se actualice según lo programado y quieres verla de inmediato, puedes revisarla manualmente. Aquí está el procedimiento:
- Ve a la página de inicio de la aplicación Pivot.
- Selecciona la tabla Pivot bajo el apartado "Nombre (Name)."
- Sigue los pasos del asistente para previsualizar y finalizar la tabla Pivot.
Durante el proceso en el asistente:
- Usa la opción Preview para ver una vista previa en tiempo real de la tabla Pivot que estás creando.
- Si estás satisfecho, selecciona Confirm (Create) para continuar.
- Si necesitas realizar cambios, cancela el proceso y haz clic en el ícono de engranaje para ajustar la configuración de la Pivot.
Una vez que confirmes, la aplicación Pivot generará la tabla y la guardará en la ubicación especificada dentro de Smartsheet.
Si el problema persiste y la tabla no se genera, asegúrate de que:
- Tienes los permisos necesarios para crear y acceder a la tabla Pivot.
- Tu plan de Smartsheet incluye la aplicación Pivot (Smartsheet Advance Package).
Si el inconveniente continúa, se recomienda contactar al soporte de Smartsheet o a tu administrador para confirmar que no existan limitaciones relacionadas con la suscripción o los permisos.
English Version
The "Create" action successfully sets up the configuration for the pivot table to run at the specified frequency. However, if you don’t want to wait for the scheduled update and want to view the pivot immediately, you can manually check it. Here’s how:
- Go to the Pivot App home.
- Select the pivot table under "Name."
- Follow the steps in the wizard to preview and finalize the pivot.
During the wizard process:
- Use the Preview option to see a real-time view of the pivot table you're creating.
- If satisfied, select Confirm (Create) to proceed.
- If changes are needed, cancel the process and click the gear icon to adjust the pivot settings.
Once you confirm, the Pivot App generates the sheet and saves it in the specified location within Smartsheet.
If you continue to experience issues with the table not generating, ensure that:
- You have the appropriate permissions to create and access the pivot table.
- Your Smartsheet plan includes the Pivot App (Smartsheet Advance Package).
If the problem persists, it’s recommended to reach out to Smartsheet support or your administrator to ensure there are no subscription or permission-related limitations.
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.

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)

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!
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.
