-
Show Multi-Contacts with a JOIN(COLLECT(...) formula -- working, but not showing as contacts
I have a Directory Sheet ('Sheet 2 -- Directory': https://app.smartsheet.com/b/publish?EQBCT=a3e35afe3e02404692195182d00936a4) with a list of Teams, Departments, and Contacts. I want to pull the Contact(s) into another Sheet ('Sheet 1 -- Pull Into Sheet':…
-
Copying rows to new sheets based on multiple selections in one column
Hello, new to Smartsheet so might not use the correct language, but hopefully someone understands what I need! In my company we host CPD sessions where suppliers will come in for an hour over lunch and teach us something new. We need to keep a record of these sessions and who attended them. I have set up a sheet where I…
-
Smartsheets tab freezing
Hello, my users have been having an ongoing issue for the last couple of weeks where the tab for smartsheets will freeze when left alone for a few minutes. It happens when in a sheet or not in a sheet. This can be consistently replicated when the computers lock screen is triggered. I have contacted support and they…
-
Does anyone have a support phone number for Smartsheet
I don't seem to be able to find one anywhere. I'm handling coordination for multiple teams on a project and I have multiple resources having trouble receiving the account creation e-mail confirmation.
-
Cross-sheet COUNTIFS Formula Not Working as Intended
I am using a helper sheet to calculate projects that are Past Due, Due this Week, and Pending Review per Requestor Email (this email comes via a form). The formula I am having issues with is the the one I am trying to create to count the number of projects that are due this week. I need to formula to count the rows that…
-
Can I combine multiple rows into one row on a Gantt Chart?
Dear all, I want to aggregate multiple project schedules into a master schedule. When copying the milestones from various projects into a single sheet, my overall Gantt Chart displays an event as a row, and each project occupies many rows. Is there any method to combine multiple rows into one row and use one row to present…
-
Smartsheet 201 - How to Build Reports and Dashboards - Free Smartsheet Webinar
I wanted to share an exciting opportunity to level up your Smartsheet skills! Tomorrow, our Customer Success team at DigitalRadius is hosting Smartsheet 201: How to Build Reports and Dashboards, a free webinar designed to help you create powerful reports and dashboards to enhance visibility and collaboration. We already…
-
Error when running out of CPU memory
Not really a question but more of a heads up. I had a sheet with almost the max rows and 6 columns and 2 references. Tried to add a column formula and my CPU ran out of memory. After the browser crashed I went back to the sheet and smartsheet threw the exceeds 2.5 Million cell reference error. Im no where near 2.5 million.…
-
Document Generator Quit Working
My document generator on 2 of my sheets just stopped inputting the data into the PDF forms. It will name the file correctly using one of the data fields but won't put the data in the file anymore. I remade my form and the automation like 10 times! The file is small, sticker size 2.25 x 1 and has a barcode font on it. This…
-
Contact support chat feature
We have an enterprise account and only just noticed this a week ago. Does anyone know when this feature was implemented and is it a live chat session or chatbot driven? Thanks
