-
Receiving an Error Code when Creating Chart
Hi everyone! I created a metrics table to count how many "Critical, Major, Lesser" observations I have per a CRO Management group for a specific timeframe (quarterly). The formula I used in the metrics sheet is as follows: =SUM(COLLECT({Audit Schedule Range 6}, {Audit Schedule Range 2}, "CRO Blood and Marrow Transplant",…
-
Modified Date in Formulas
I am trying to use the auto-populated system column "Modified" in formulas. Specifically, I am trying to create a "Modified Helper" column that takes the "Modified" column date alongside the time, checks if it is after midnight, checks which shift it was logged under, and log the auto-populated "Modified" date to reflect…
-
Ich habe eine Business Lizenz und möchte Berichte für Mitarbeiter freigeben.
Hallo. Ich bin noch nicht lange hier bei Smartsheet und habe einige Probleme zu verstehen, wie ich Mitarbeiter für von mir erstellte Bereiche oder Berichte zum Bearbeiten oder Betrachten freigeben kann, ohne kosten zu produzieren. Ich habe diverse Berichte für Kollegen als "Bearbeiter - kann nicht freigeben" freigegeben.…
-
Integration between Smartsheet, Zapier, and ChatGPT (Agent Mode)
I’m exploring ways to automate vendor data validation using Smartsheet integrated with AI tools. Is there any built-in AI or agent mode within Smartsheet that can handle data validation and automation directly? Or do I need to rely on external integrations such as Zapier or ChatGPT 5 (agent mode) to achieve this…
-
Set Dashboard as Default Homepage for All Users
Hi everyone, Is there a way to set a dashboard as the default homepage for all users upon login? Ideally, we’d like users to land directly on a particular dashboard instead of the usual default page. Is this possible through configuration, or is there a plugin or workaround that can help us achieve this? Thanks in advance!
-
Get hierarchy/parent of sheets
Hi, I came across a blog mentioning that the Sheets folder feature has been deprecated. As SmartSheet users, we now need to migrate our sheet files and folders into workspaces. Additionally, when calling the API to list sheets, it returns all sheets within the account or profile. So, until it will be migrated to a…
-
Cant log into Smartsheet after I changed a User from Member to Viewer
I am the System Admin for Smartsheet and a long time user. I changed some users from a Member license to viewer and now they are not able to log in to Smartsheet. I have submitted a case and am waiting for a response from support. Short of creating a new login with a different email address, how can I best resolve this…
-
Sharing Report but Not the Source Sheet
I would like to share a report, but not the source sheet. The source sheet has personnel information that I do not want to share with our customer, but I made a report with the information I am comfortable with sharing. However, when I share the report, it is blank because the customer doesn't have access to the source…
-
Integrate with MS Booking
I want Smartsheet to receive the data from the MS Booking calendar that I created. My current work-around is to export the MS Booking file to a sharepoint folder and then data shuttle the information nightly into Smartsheet. Would be better if the MS Booking form intake just populated the Smartsheet directly. 😊
-
Sheet Access report
Hello. Me and my team are doing an audit of users who have access to edit items in our account and one of the reports we're using is the Sheet Access report under the User Management section of the Admin Center. However, we're running into some weird things. When we dig into the Sheet Access report, we sometimes notice…