-
Generate formulas AI tool available in AU!
December 11, 2025 Generate formulas is now available for customers using the Smartsheet AU environment in Table view. This AI tool enables you to quickly create working formulas in the formula panel using AI, without needing to master complex functions or syntax. Simply describe what you want the formula to do in plain…
-
Can you use a form to allow users to select available time slot
We are trying to utilize a smartsheet form for recipients to select a time slot for a specific training we are doing. We are offering a training to some internal folks but are limited in seats for each session. There are 12 sessions, some on the same date just at different times. Will use form to - * Allow recipient to…
-
countif from 8 different sheets with data criteria
Hello, I have a head scratcher here, I have 8 different sheets that I am trying to pull counts from and only from a certain day. Example: All sheets have a date of outreach, all sheets have a outcome. I want to pull the count of all outcomes marked "Mbr Reached" from 12/02/2025 from all 8 sheets. Question: Is there a…
-
How to calculate % Planned in Father Rows?
Hi Community I created a new column to calculate the planned percentage in my project; however, in the father rows is not calculating correctly, even if I tied the percentage between complete and Planned, the percentage is not the same. I am using the following formula =IFERROR(IF(Finalizar@row = Inicio@row , IF(TODAY() >=…
-
Inventory Tracker
Hi - I am looking to build an inventory smartsheet, but am having difficulty setting it up. I am not a guru... We want to input all of our inventory by barcodes (auto populating and grouping same-type products) into our main warehouse. From there, we want to scan those barcodes and deduct x amount of inventory to our…
-
Getting the Triggered by at least 5 other workflows but nothing is daisy chained
Hello, I'm seeing this error for the first time as I expand some capability in an existing workflow. Here's how this section with the error works. Scenario: a user puts in a request on the form with a check box indicating they will later upload the required file attachment. Automation sends a request for Approval with…
-
Feedback Needed on Status Rollup Solution
Hi all, I have a bunch of underlying sheets that have the exact same setup due to a template and it has a status field with a drop-down of about half a dozen different options that go sequential order from not started to complete and verified as complete from leadership. We also have hierarchy so there is level 0, 1 and 2…
-
How can I get calendar view to stop showing wildly inaccurate dates?
I have a grid view and two columns are assigned to start and end dates that define some intervals that get mapped to calendar view. The dates are all formatted correctly in the grid view. The problem is that the dates that show up on the calendar view are wildly inaccurate. Certain events show up as the wrong dates,…
-
How to automate data involving dates and sum totals
I have been researching this topic for some time now and have been having trouble finding an answer - hoping the Smartsheet hivemind can help! OBJECTIVE: To obtain a sum total of data submitted via a Smartsheet form, based on submission date. CONTEXT: I work for a transportation company, and we use a Smartsheet form to…
-
Can't Find Option to Reference Another Sheet with new AI-enabled design
I was a away from Smartsheets for a few weeks while switching jobs and I can't find some stuff now. A month ago, when doing formulas that had the capability for a cross-sheet reference, Smartsheet would offer you a link to "Reference Another Sheet". Smartsheets a month ago: Now, when I try to use a formula, a pane on the…