-
NEW! Your survival guide to formulas is here. Meet the Formula Handbook.
Hi Community, Whether youβre summing child rows, calculating budget minus actual, or doing cross-sheet data lookups with multiple criteria, formulas are a must for tailoring solutions to your needs. The new Formula Handbook is here to help formula beginners and pros alike. This template contains: A glossary of allβ¦
-
Formula Range
Hello Community, Is there a way to make the range for a formula start at a certain row and then continue on once other rows are created? I've found that leaving the end of range number blank or putting a future number row that has not been created causes the formula to be Unparseable.
-
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.
-
Move data from a column into a cell
I would like to pull the name that is listed in the Name column into the Primary Column. Note that the name could be listed multiple times in the Name Column.
-
Sorting by Months
I have entries in a sheet that include a date that is in the past. There is also a monthyear column used for grouping. I would like to sort the months from most recent to furthest out as they are related to the calendar. What I see is below. I would like July to be first, then June, then May, etc. Thanks! Judy
-
SUMIFs Formula Help...
I am trying to calculate a specific persons total numbers across four columns in the Sheet Summary. Below is the formula that I have, but it keeps returning #Incorrect Argument Set. Pleaseβ¦what am I doing wrong. :) =SUMIFS([Motion Permanent Total]:[Motion Permanent Total], [Motion Temporary Total]:[Motion Temporary Total],β¦
-
Net Days showing 36500 no matter the actual dates provided.
I am trying to use the NETDAYS function, but it will only respond with 36500. The result should be like 60. The dates I am trying to count are part of some simple (COLUMN + COLUMN) formula.
-
Date Formula that needs to run into following year
I have a sheet with one column (start date), next column 3 months from Start, third column 6 months from start. Formula for 3 months from start date is: =DATE(YEAR([start date]@row), MONTH([start date]@row) + 3, DAY([start date]@row)) It's working fine for cells that are calculating for years 2025. For cells that will needβ¦
-
Matching Formula
Hello Community, I'm looking for a formula that will lookup and match a name with the same name from another sheet AND if there is a check box checked in a column on that row, it will automatically check the box on my new sheet. See my very simple example. I can give more context to what I'm trying to do if helpful. Thanksβ¦
-
Trying to return 3 months prior to Date Column
Hello, I am trying to make a column to return dates 3 month before the date in another column. Essentially going to be notifying teams 3 months before something expires. I have a column for the dates. It is set to "date" and i'm using this formula in a helper column =DATE(YEAR(DATE@row ), MONTH(DATE@row ) - 3, DAY(DATE@rowβ¦
-
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β¦