Hello all, I am looking for some assistance with a COUNTIFS formula. I have two columns of large data sets (staff ID numbers), one outdated and a new one representative of the current organization. My goal is to cross reference the two and see which IDs appear in both lists and which do not. I originally started playing…
I have created a purchase order sheet and form which auto generates a number each time. How do I reference this number to pull it through into the form completion confirmation message and/or email?
Hi, I've spent way to long trying to figure out if Smartsheet can do what I want it to do so I thought I'd ask the experts. I have about 70 events a year and 150 tasks to complete for each event. It is just me working on this so I don't need to assign or escalate. I need to have reminders on certain tasks for different…
How will the new email OTP login method impact Live Connector’s 32-bit ODBC connection?
The Task Progress column is linked to the % Complete column. when someone inputs a value of 100% in the % complete column, the task progress changes to a Green dot, and the same goes for when the % complete is 0% - Red dot, 1-99% - Yellow dot. I would like to add a gray dot in the mixture so I need a new formula to reflect…
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…
Has anyone created a successful Safety Management System using smartsheet? If so, do you have a template?
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…
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…
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…