-
Why does Smartsheet add a single quote before an integer that begins with 0?
A single quote keeps getting added when a 0 precedes an integer regardless of the entry method for the cell’s value (e.g., when the values are imported into Smartsheet from an Excel file, when the values are copied and pasted into Smartsheet or when the values are manually entered). Example: 099999999 changes to ‘99999999…
-
Proper Safety Management System (ISO 45001)
Has anyone created a successful Safety Management System using smartsheet? If so, do you have a template?
-
Formula to calculate and copy dates based on form submissions and standard timeframes
I am very new to Smartsheet and I am struggling to find the right formula for a sheet. I am working on a access sheet linked to a form. Different access categories have standard timeframes, for others, the person submitting the form will have to indicate a specific date. I was planning to have a column where to have all…
-
Automatically fill a sheet from a pdf or word doc
I have a word form that one of our teams needs to fill out. They then send me a pdf of the form and I need to enter the data from the form into a Smartsheet log. Is there a way to automatically scan the pdf and enter the data? I can also do it from the word form if needed. Creating the form in Smartsheet directly is not an…
-
Bring Data From Another Sheet (INDEX, MAX, COLLECT, MATCH)
Hello Community, I need to bring data from one sheet to another. I usually accomplish this using INDEX, MATCH combination. My challenge right now is the following: Sheet 1 has unique records. Sheet 2 references Sheet 1 on a unique identifier (taskid), but there might be multiple records in Sheet 2 for the same taskid. I…
-
NETDAYS returning #INVALID DATA TYPE
Hi - I'm trying to calculate the number of days between two dates in a sheet. I have both of my columns that contain the start and end dates set up as DATE column type. They both contain dates. I use the formula "=NETDAYS([Hotel Check-In Date]@row, [Hotel Check-Out Date]@row)". I have tried making the results column a…
-
chart - create % of task per assigned to
Hi I have a task list sheet where I assign user to tasks. Those tasks are marked as In progress, Complete, Not started, etc... I want to create a widget on the dashboard that will display something like the screenshot attached. Being new to Smartsheet, can someone provide me step by step instructions on how to achieve this?
-
Is it possible to use the "request an approval" automation without "send me a copy of responses"?
Hello, We are developing an outward-facing sheet that will be used by external clients. We need them to select Yes or No on a question provided. The issue we're having is related to the "send me a copy of my responses" option at the bottom of the approval. The external clients are able to select that, and then receive an…
-
Cell shading not saving when I change it
everytime I update the cell shading to match the rest of the sheet or change to just be white, the change does not save, even if I save myself, it just goes back to the same way. from the picture I am trying to change the purple to grey and the white under the grey to grey
-
Printing the gantt chart
Hello, Is there a way to print ONLY the gantt chart and not the columns? Thank you!
