-
Yield year if criteria is between two dates in two columns.
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 am stumped with yielding year between two dates in two columns. Thanks!
-
Force calculated date to change to first following Monday if not already a Monday
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 force the date if not currently a Monday to be the next following Monday?
-
Count if today and multiple criteria
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 entries are in the Amsterdam column when it is today's date. Row 2 shows today's date (16th March) and the formula should…
-
At Risk Flag turning red based on Start & End Date Formula
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 in any other Staus but Completed by the End Date, mark the flag red in the At Risk column @Andrée Starå Thank you!
-
Comparing Data Across Multiple Columns on the Same Sheet
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 represents what was received. The ID numbers in these columns could be in either column, based on how the data was entered…
-
Formula and automatic hyperlink cell back to other sheet
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 this is helpful: we have a vendor portal where our vendors send in their invoices via a form to a sheet, then in one of the…
-
Filter to show recent and active meeting items
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 rows and workstream headers, i really only have two types of row - note or action. In both instances, they have an assigned…
-
Seeking formula to catch mismatched dates for a single project across multiple Smartsheets
Hi, Smartsheet community. I am hoping someone can provide guidance on a path to solve this problem. Since our team doesn't always get alerted when a project is rescheduled, we are looking to compare dates between our main Smartsheet and the information we extract from our company's master scheduling platform and…
-
Best Way to Pull A Ton of Data
Hello Community, I have recently been given the challenge of pulling a ton of data from a source sheet to a target sheet, and am trying to figure out the best way to pull all the data efficiently and not run out of space too quick. Unfortunately we cannot use data mesh because each row has 7 target columns to pull from.…
-
Formula no longer working in Sheet Summary
I have a sheet with sheet summaries that were working for the last month and I recently updated with data shuttle and its no longer working. I keep getting the sum of 0 even though it was working before. =SUMIFS([Quantity (G)]:[Quantity (G)], Material:Material, CONTAINS("200002", @cell), [Pick-up Date]:[Pick-up Date],…
