-
Need Help w/ Counting Week of
I am trying to count how many items on the list have a scheduled pickup date for this week. I already created a week number column. Here is the formula I am currently using but I keep getting an error message. What am I missing?
-
Date Calculation not working correctly
In my Operating Calendar sheet, I have a Due column (date). This due date column should be calculating based on a formula that adds the "Days From Pricing Group OR 1st Departure Date" column to the "Pricing Group Date" Column (=[Pricing Group Date]@row + [Days From Pricing Group OR 1st Departure Date]@row). Both the "Days…
-
How to find the Nth weekday of a given month?
I'm working on a formula that will provide the date of the 3rd Thursday of the month. That much I have working, but am trying to modify it to work for any weekday of any month. As of now the first and last weeks of the month are causing issues (returning a date from previous month, returning a date in the next week, etc.).…
-
IF formula help please
I have this formula that is working perfectly, it returns the value in number of days between Date submitted to Todays date OR Date submitted to Date Comments Log Received =IFERROR(IF([Comments Log Received]@row = "", NETDAYS([Date Submitted to SJTA]@row, TODAY()), NETDAYS([Date Submitted to SJTA]@row, [Comments Log…
-
Project Variance Formula Using Levels
I need help with a formula that calculates variance between actual durations and planned durations set at the start. We frequently need to reset the baseline throughout a 3-5 year project, and I would like a historical record of where we started and where we ended, without having to copy/paste current baselines before they…
-
Formulas referencing too many cells on source or destination sheet 👎
"Formulas are referencing too many cells on the source or destination sheet. To run this workflow, please reduce the amount of cells referenced by formulas." How do I figure out how many and what formulas are connected to the sheet causing this error? Neither the source nor destination sheets have the blue or black ▸in any…
-
1st - 5th highest value that meets criteria - cross-sheet referencing
I have a Smartsheet entitled 'MASTER List' with the following information (see Image 1 below). The columns 2021, 2022 and 2023 use cross-reference formulas to count the number of times these courses appear in other sheets for the given years. All courses are categorised into one of seven categories: Health & Safety,…
-
Having an issue with COUNTIFS with multiple criteria and referencing another sheet.
So, I am having an issue getting COUNTIFS to properly calculate. What I am trying to do is have it count rows with a status of TARP and a co-pay of $0.00. This is the current formula. =COUNTIFS({PARENT ACTIVE 2a Range 1}, CONTAINS("TARP", @cell), {Parent Co Pay Amount}, CONTAINS("$0.00", {Parent Co Pay Amount})) Now…
-
Trying to get the last day of the next month based on another date column's value...
Hello, Community! Current formula (returns the first day of the next month) works: =DATE(YEAR([Earnings End Date]@row), MONTH([Earnings End Date]@row) + 1, 1) I'm trying though to have it return 7/31/23 instead of 7/1/23...what am I missing?
-
How to calculate Status Indicator using %Complete and Target Finish Date
I am trying to achieve the following: IF the %Complete equals 0%, then status indicator is Gray. IF the %Complete equals 100%, OR the %Complete is less than 100% and Today is before the Target Finish Date, then the status indicator equals Green. IF the %Complete is less than 100% and Today is within 1 week of the Target…
