-
AI formula generator is not working
Dear Community, Kindly help to find the right way to resolve my issue. For about a month I am trying to get help from Smartsheet support as AI formula generator is not working with my account (Enterprise license), no matter what wording am I using. At the same time, at my coworkers accounts all works well. Smartsheet…
-
How to sum cells from different sheets?
I have six sheets with numbers in each cell. I want to make a 'TOTAL' sheet that sums up each corresponding cell in each of the six sheets. For example, sum the A1 cell in Sheet 1, 2, 3, 4, 5, 6. And then sum the A2 cell in Sheet 1, 2, 3, 4, 5, 6. Basically the A1 cell in the TOTAL sheet should be the sum of Sheet 1, 2, 3,…
-
Vlookup/Indexmatch (retrieving date from one smartbook to generate in main sheet)
Good afternoon I have figured out the vLookup formula in Excel but I am having issues in Smartsheet. I want to enter a name in my main sheet (2025 OT Tracking) and then I want the Cost Center to auto-populate from my second sheet (CC&Names). I have looked at numerous formulas and I am still struggling.…
-
Sum Multiple Criteria
I'm looking to sum the total in the CS Error Cost column anytime the Responsibility column equals CSC, ISG or UAL. I've attempted different nesting versions of the SUMIF and SUMIFS but keep getting an error. Below is one example of what I attempted. =SUMIF([CS Error Cost]:[CS Error Cost], Responsibility:Responsibility,…
-
Multiple Condition Duplicate Line
Hello, I am creating a tracking system for PO's that need to be entered into a system. The problem is that a PO can be split into multiple truckloads and delivered to the facility on mutliple dates. The facility enters each PO that is needed based on a schedule but if the PO had been received previously, they do not want…
-
Challenge with counting different columns in a sheet when a reference to another sheet exists in a d
I have entered the formula below to count the number of times a box is checked in a particular month in another sheet. When I try to apply the same formula to another column in the sheet below (writing manually or copy/paste) and select a different column in the other reference sheet to pull the checked box count from it…
-
Update Request Not Working as Planned
Hi there, I have an automation for my team's project sheet that sends an update request for every item that has a status other than 100% or "Not Supported." But it's sending update request for projects that are at 100%, which is both confusing and annoying for my teammates. Below are a couple of screenshots. Does anyone…
-
Formulas just won't formula :-(
for context - i would put myself as entry level for formulas in smartsheet. ChatGPT has been very helpful but clearly i'm doing something wrong. I've set up my managed references so it is pointing to the created date and satisfaction score. The forumals i'm using are looking at a range of created dates (month of july) and…
-
Using the Greater/Lesser than with %'s
I'm trying to build a formula for 3 separate columns where it generates a number on whether the % provided is below or above a certain threshold: Unauthorized Return Rates < 0.5% Administrative Return Rates < 3.0% In my current formula it should say if the % is greater than 0.5%, it should list "1", and if less than 0.5%…
-
Trying to combine 2 AND functions with an OR
Hi There! I am new to SmartSheets and am working on a way to automate a process using the OR with AND's and running into trouble. Basically, I am trying to check a box in a column if any of the following is true. If the Model type is 1 AND the version is less than 9 OR If the model is 2 AND the version is less that 18…