Formulas
Discussion List
- I'm wondering if I can have a helper column/cell that houses the year instead of including 2023 in all of my formulas (we're talking over a thousand cells). I want to have a helper cell that has 2023 …
- Hi all, going a bit crazy trying multiple variants on these formulae to get my desired outcome. Hoping someone can put me out of my misery. In my source sheet I have columns and rows like this: In my …
- Hello, I would like to get a formula that sums checked boxes only and also give me the count based on project status. This "Metric Sheet" refers to a regular sheet assigned by team member.
- Hello, I am trying to yield the Year if Start date is greater than or equal to 1/1/2023 but pre-marketing date is less than or equal to 12/31/2023. I was fine with a simple year in a single column but…
- I have a few columns where the dates are based on a formula. It is imperative that some of the date column MUST be a Monday but due to the formula some of the dates do not fall on a Monday. How do I f…
- Hello community, My formula needs to read data from two columns with the combination of a CountIfs, Distinct, Today formula I think. On row 16 in the count column, I want the cell to count how many en…
- Hello everyone! I am trying to automate some of the project plans, and I was wondering what the best way is to express this in a formula: If Status is Not Started by 3 days after the Start Date, and i…
- Hello Smartsheet Community! We have (4) columns of data that we need to compare against one other (2 sets of 2 columns) One set of (2) columns represents what was ordered, the other set of (2) columns…
- In a sheet, we have a column formula taking a value from another sheet using 'reference another sheet' we would like it to create a hyperlink back to the other sheet where it took the value from. How …
- Hello all, For my project meetings i have a combined agenda for notes and actions using a standard form. I am trying to apply a filter to keep things more recent when we review it. Excluding parent ro…
