-
Help Sum items by specific year in a row.
Hello, I need help creating a formula to help me to only sum totals in a column by specific year. I have multiple years of financial data in a sheet. I want the formula to be able to look at the row - if its 2023 listed, sum their amount and put it in the column for 2023 item totals. If its 2024 items sum their amount and…
-
Index Match Multiple Criteria across sheets
I am trying to create a formula that matches criteria between two sheets, then populates a cell based on the criteria's results. The goal is to use an index/match to populate the "fee" cell in the second picture based upon the client and service level. Could someone explain how to create this formula? Thank you.
-
COUNTIFS + OR - Forumla Help
You're all so amazingly helpful that I'm back. I think this is an easy fix for most, but I'm scratching my head. I have a column named Status with multiple drop down options, of which only one can be used. I also have a column named PMO that is a checkmark. I want to get a count of PMO flagged rows that fall within several…
-
Show week commence date rather than actual date
Hi, Can I please ask if it is possible to show the week commence date of a date input (e.g. w/c 20th Feb) rather than 24th Feb 2023 as the specific date for example? Thanks, Sin Nee
-
COUNTIFS- CONTAINS/FIND/HAS
Set-up: I have a data prep sheet that references a master sheet and some other sheets so it is easier to set up a dashboard. I have a list of departments in one column (Column5), and the count formula in the next column. The formula works when there is one department listed in the reference but not if there are multiple…
-
TotalFloat with multiple phases
Hello, are there recommended best practices for handling dependencies when calculating TotalFloat, =TOTALFLOAT([Primary Column]@row)? In this example, Milestone 0 requires that Tasks 1-3 be completed and is a predecessor for beginning the next project phase. TotalFloat calculates values for tasks 5 & 6, but it does not…
-
Incomplate Online Formula Example - MONTH
Hi Support, MONTH Function | Smartsheet Learning Center Unsure where to post this, but the example is missing an end bracket. See below. =COUNTIF([Sold Date]:[Sold Date], (MONTH(@cell) = 2) When the MONTH function contains a blank cell within the range of dates it is reviewing, it will produce the #INVALID DATA TYPE error.…
-
Formula Help Please - Sheet Summary
Hi everyone - I have a GIANT sheet I'm working with that contains our project portfolio. I need to add summary fields to capture Project Status (from a dop down field in a column) across 10 different Sponsor Divisions (also in a drop down field within a column). I can't seem to crack this one. Can someone help? I'm sure…
-
Can Only reference a total of 100000 cells (combined) from other sheets. Please select fewer cells a
Hi All I am a newbie to Smartsheet, been working on it for a few months only. I am getting this error. Google is not helping me much. Please can a good samaritan assist me in this forum? Thank you so much. Existing formula that I am trying to update =COUNTIFS({Archive Sales Stage}, [Primary Column]@row, {Archive BU},…
-
Formula for project health
I have the following formula and I want to add: Turn task health Blue for START DATE column if today's date is before the start date. Leave Task Health blank if there is not Start Date or Target End Date =IF(OR(AND([Target End Date]@row <= TODAY(7), [% Complete]@row < 0.5), AND([Target End Date]@row < TODAY(), [%…
