Formulas
Discussion List
- I am trying to include a calculation only if a certain qualitative value is met. Trying to have the column indicate "Days Over Deadline" by subtracting the "Submission Deadline from the Submission Dat…
- This formula is almost perfectly pulling downtime by examiner and production date: =IFERROR(INDEX(COLLECT({downtime - downtime}, {downtime - production date}, [Production Date]@row, {downtime - examin…
- I have a column of dates. New rows are being added over time. I count how many occur in each month. In a separate metric sheet, have 12 formulas, 1 for each month, that look like this. =COUNTIFS({Date…
- I am working on a telecom cleanup project and have an export of all the telephone numbers at each site. I'm wanting to take the telephone numbers in each cell and combine them into 1 based on the bran…
- I am trying to get the sum of approved projected expenses only. I can't figure it out I have been trying SUMIFS and SUM(AND formulas but can never get it to return a result. I can get one or the other…
- Hi Super Guru's, Could I kindly ask assistnace on where my formula is incorrect. Getting #UNPARSABLE error =COUNT(COLLECT(Status:Status, ="Complete"),[Finish Date]:[Finish Date], >=DATE(2024, 1, 1), […
- I have two columns, one is an index collect formula and the other is a simple subtraction of two cells. I want to create a formula to display a message if the two cells are not equal. I created the fo…
- Hi all, I was wondering if there is a formula or drop down function that can auto populate words or drop downs? As seen in my conditional formatting for "Days Left Till Expiration it conveys whether i…
- I'm trying to calculate the number of instances where only two items (the words content and functionality) appear in a cell. My current formula is not pulling the correct count. Any suggestions? P.S. …
- I am having trouble coming up with a way to search within values using a Collect formula. I have three sheets, one which shows the courses a user has completed, one which shows the courses included in…