-
Adding multiple columns at once
Hello, Based on a previous post I saw in regards to rows, I wouldn't be surprised if multiple columns cannot be added unless done one at a time, however if it is possible can someone please assist? I would like to add about 5 columns at the same time without having to add them individual and name each one at a time. Thank…
-
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…
-
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…
-
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…
-
Issue with Record Date automation.
Hi everyone, I’m hoping someone can help me with an issue I’ve been running into. When a user submits a form late in the evening — sometimes as early as 8:15 PM — the “Record a Date” automation occasionally logs the following day’s date instead of the actual submission date. Originally, I used =DATEONLY(Created@row ) to…