-
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.).…
-
Why is the Nested IF Statement showing "Incorrect Argument"?
Please help, not sure why my nested if statement is incorrect. The formula I am using is below: =IF(AND([Completed Date]@row <> "", [Review Date]@row <> ""), "green", IF(AND([Payroll Date]@row <= TODAY() + 31, [Payroll Date]@row > TODAY() - 31), [Payroll Date]@row = "", "Red", "Yellow", "Blue")) Not sure where I am going…
-
Why are my symbols all red instead of red, yellow and green?
I am using a formula to change the color of my symbol based on whether another column has certain text. If the Status Option column contains the text "OK:" it should trigger the status summary column to show a Green symbol. If the Status Option column contains the text "Needs Attention:" it should trigger the status…
-
formula to fill in one sheet based on the dropdown symbol in report from another sheet
Hello, I need a formula or a suggestion for a better structure. I have a Report from Sheet 1 and then the Sheet 2. I need to add the names to Sheet 2 based on the symbol drop-down selection in the Report from Sheet 1. a. Report from Sheet 1: the faculty marks the weeks (in columns) they are not available in this report. b.…
-
Prorate Fundtion
Hello, I was wondering what the best prorate function would be if I only had the effective date and amount?
-
Left and Find Formula Issue
Are there any glaring issues with the following formula? =LEFT([AR - Run 1 Size]@row, FIND("""", [AR - Run 1 Size]@row) - 1) I'm trying to return the leftmost text that occur before the quotation mark. For example, Original string: 2" InchFisher399 I want just the number 2 I just get #UNPARSABLE
-
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 can i find DISTINCT names from multiple JOIN(Distinct(Collect)
I am collecting instructor names for courses from multiple sheets which works fine, but it may list the same person multiple times as it finds them in each sheet. =JOIN(DISTINCT(COLLECT({ccsu23}, {cnsu23}, Course@row))) + JOIN(DISTINCT(COLLECT({ccsp23}, {cnsp23}, Course@row))) + JOIN(DISTINCT(COLLECT({ccfa22}, {F22CN},…
-
default formula in hidden field
I need to reference the content from one field in another field on the same row. I want the formula as the Default Value of a hidden field on a form. The formula I'm using is =[Team Member]@row. When a new form is submitted, the field with the formula shows a single quote mark at the beginning, and therefore it's not…
-
Countifs With Multiple Criteria
I am trying to count the totals if a certain criterias are met. Per example below I am trying to count if client is A and B where "Initiative" is NOT "N/A" and Progress for both "Waiting for Pricing". I tried the formula below and not correct syntax and logic. Any help would be much appreciated. =IF(COUNTIFS({Client}, ="A,…