-
Gantt Chart Dependency Number Scaling When Zooming Out
I have been a Smartsheet subscriber for many years and use Gantt charts extensively for construction, fit-out, and engineering project scheduling. One recurring issue significantly affects productivity when reviewing project schedules with predecessor relationships. When zooming out on the Gantt chart to see the overall…
-
Analyze, translate, and summarize your sheet data instantly with AI-powered Smart Columns
May 28, 2026 Eliminate manual data processing and get instant insights into your data with Smart Columns. Instead of spending hours manually categorizing feedback, translating individual cells, or summarizing updates, Smart Columns bring the power of AI directly into your sheets, so you can synthesize and transform data at…
-
AVERAGEIFS or AVERAGE(COLLECT()) Help
Hi! I am struggling to get this formula to work correctly. The Smartsheet-AI generated formula is returning #UNPARSABLE and I am not too familiar with Average Collect. The goal: Average the column "Total Days Open" if the following criteria are met: column "Business Type" is NOT "retail" and column "Division" is "Northern"…
-
% Complete Column Appears Broken
The screenshot shows an assignment I am working on for an online class. I have a question about the lines highlighted in yellow. The "% Complete" column is supposed to show a calculation of the children's done percentage, I think. Am I understanding that correctly? If so, the Campus & Grounds line (NPI-052) showing 51%…
-
Ownership transfer
I'm the new operations manager at my company, however our previous operations manager resigned but before he did he did not transfer ownership of all our smartsheets. So when there is a notification of something we have no way of knowing because it continues to go to the previous owner. Since I'm not sure what access level…
-
Copy rows to other sheet as values only?
What are some tips please to copy/move rows to other sheet as values only? Specifically, rows which contain column formulae. Is there a known workaround, or should I just use DataMesh? My main issue with this is that I can't copy columns containing column formulae. Thanks for your help, Matt
-
Internal 500 Error
I am trying to connect via API to the shared sheet which I have access to edit. I get this error. Yesterday it was working fine, today I started to get this error. Please help asap. "HTTPError: 500 Server Error: Internal Server Error for url: https://api.smartsheet.com/2.0/sheets/…"
-
Personal Account for Fun (And Practice)
I am always trying to advance my skills and so, being the unapologetic Smartsheet buff that I am, I now pay for my own personal Smartsheet account to play around and practice my skills on personal projects. In my heart I would like to someday live somewhere else and to help me determine where…. I built a Smartsheet. Using…
-
Assistance needed with the following formula...
I'm trying to put the correct data (person) in the correct column for an Employee and their Management hierarchy, using the following formula: =IF(VLOOKUP(Worker@row, {Active Workers Report - Mgmt Lvl}, 5, false) = "Team Lead", {Manager}, "") Can someone help me correct the formula, so the Name of the Team…