-
Conditional Formatting on Symbols Based on Percentage
Hi, I have searched a few articles to help apply a formula to update a symbol based on conditional formatting. Unfortunately, I'm still a little lost. I have a Weekly Project Health column (Symbol type), where users can choose manually the desired status. I also have a Weekly Participation Rate % column (Text/Number type),…
-
Forms - Fields Type - Timestamp
I recently started using Smartsheet Forms. One of the data types that I am interested in collecting is that of time in "HH:MM" format. Smartsheet does a good job having a variety of field types but I wonder if it could be expanded to include time?
-
Long-time lurker; first time poster
Hi all! I work for a hospitality company and am lucky that we specialize in the great outdoors. My favorite outdoor activity is paddleboarding with cycling and running occasionally thrown in to the mix. I've worked with Smartsheet for about 4 or 5 years but am just starting to be more active in the community. My favorite…
-
Looking for assistance with a formula
Hi all, I am new to formulas and functions in Smartsheet and have a large sheet that I would like to summarize using an "average" formula/function. I need to include at least 2 separate criteria to filter correctly and I am having trouble combining the avg and collect functions as suggested in the functions list. I have…
-
¿Cómo reflejar automaticamente archivos adjuntos como pdf o imagenes de una hoja a otra?
Mi pregunta no se refiere a vincular celdas ni a compartir valores entre hojas. Me refiero específicamente a los archivos adjuntos (PDF, imágenes, recibos, etc.) que se suben a una hoja.Me gustaría saber si hay alguna forma de reflejar o mostrar automáticamente esos archivos adjuntos en otra hoja, ya sea mediante…
-
making options in dropdown unavailable if selected already
How to make dropdown options become unavailable (in both forms and sheets) once they’ve already been selected. Example: If a patient books an appointment, that time slot is automatically removed or disabled so it can’t be chosen again.
-
Data from Smartsheet form not populating in Sheet
I have entered a number of forms today and none of them are coming through to the sheet, I have checked the rows below and searched for the primary data and no matches found. Any ideas what could be going on?
-
Closing dynamic view side panel on save
Is there an option to close the dynamic view side panel after the user has clicked Save? If not, is there a way to display a confirmation message after clicking Save?
-
Need Help! "Unable to determine your identity, therefore we are unable to process your request."
I am working on a solution (Automation) that allows people to approve a certain request (from the form). In the approval workflows I created, I am sending an automatic approval request to an email indicated in a cell. The recipient received the email request, but when opening the request (clicking the button in email), the…
-
Need help in formula function
I'm not able to get this formula to function in Smartsheet. The material ordered date is 9/3/2025. Am I missing something to get the date rage to populate? =TEXT([Material Ordered Date]@row +28,"MM/DD/YYYY")&"-"&TEXT([Material Ordered Date]@row +42, "MM/DD/YYYY")