-
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/…"
-
Creation of Dedicated Time field on Sheets and Forms
If I am creating a form that asks submitters to enter a time, it would be helpful to have a dedicated Time field available. It would also be nice to have validation in this field that requires the input to be in 24 hour or AM/PM format.
-
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
-
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…
-
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…
-
% 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%…
-
Duplicating a Report Sheet in Smartsheet
Hello. I have a report, and I want to use the same settings / filters on the report page but for different projects, so I "saved as new" and renamed it at the top, BUT, how do I clear it out so there's no existing information entered that's on the original report? ( I hope that made sense ) - any help or suggestions are…
-
Audit-centric tracking report
I am trying to figure out the best way to create a sheet for tracking all programming changes made for our development team. We have several different features that can be updated at different time, and i need to be able to track the latest version, who approved the release, and the release date. Ideally an audit report…
-
Pause sheet sharing without having to re-share
I could not find a previously submitted request, so apologies if this is a duplicate. It would be very nice to be able to pause sheet sharing temporarily (aka Check-Out the sheet) so that updates can be made without other users logging into a work-in-progress. I manage several complex schedules and budgets, and constantly…
-
Portfolios Space- How to access summary statistics in Project list
Using the new portfolio feature, how can I access summary statistics from the built-in project list? I cannot get to grid view so I am unsure how to create summary statistics. Thanks!
-
Merged: Document mapping from PDF
This discussion has been merged.
-
Merged: Customise links within email notifications
This discussion has been merged.
-
Multi selection form into single rows
Hi all, I have a form that allows multiple selections. Once the form is submitted I need the each selection to be added as a new row. I have several issues: -Selection list extensive (50+) therefore cannot be written as separated columns as suggested earlier. -Users will have a hard time to submit a form for each item and…
-
2 of 2: How to send Outlook emails using a template populated with Smartsheet data and triggering from Smartsheet
Continuation of 1 of 2 : How to send Outlook emails using a template populated with Smartsheet data and triggering from Smartsheet Details of how to send Outlook emails using a template that is populated with Smartsheet data and triggered in Smartsheet. This solution is complex. Some details have been blocked out for…
-
1 of 2 : How to send Outlook emails using a template populated with Smartsheet data and triggering from Smartsheet
Details of how to send Outlook emails using a template that is populated with Smartsheet data and triggered in Smartsheet. This solution is complex. Some details have been blocked out for privacy. I had to split this into two posts due to the length. 1 of 2 : How to send Outlook emails using a template populated with…
-
Countif for Days Elapsed between two dates
Hi - I have a tracking sheet - it logs date when we receive a request and then a date when the request is fulfilled. I need to calculate how many rows in my sheet where the date rec'd to date of completion is 5 days or less - I'm doing this in a Sheet Summary field. I asked the AI for a formula and it gave me this:…
-
Report for due dates
Hello! Does anyone know if there's a way to create a report for specific projects that reflect tasks that would be due on the same date? For instance, if several projects have the same due date, it will show up as such on the report so the manager would see this and due dates would not be overlooked. Any assistance is…
-
License versus Seat Members
The change from our 6 licenses to 25 members sheets has caused major disruption within our company. Previously, only the 6 licenses could create sheets, and ll other users could edit…. Now only member seats can edit and my 6 licenses is now 25 member seats. I previously had 40 users that had editing rights so they could…
-
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…
-
Current User Report Filter to Include Group Memebers
I currently have a report that is filtered to show tasks assigned to the “Current User”. The Current User may have teams members who help them – say User A has three assistants. I would like the Report to allow the assistants to also see the tasks assigned to User A. There are multiple Users who have assistants…