Happy 2024 everyone, I hope your year is off to a great start! I'm back requesting help to get some formulas working. I am trying to use the countif formula to count a column in a sheet. I am trying t…
how would i write a formula to pull the avg number of something in the same field across different sheets, or better yet how could i write an avg formula to pull the data from a report into a sheet in…
How do I use the following formula to pull information from the "place holder" field from multiple sheets? =COUNTIF([Assigned To]:[Assigned To], "place holder")
Guess what...it's me again. I need some help getting these two ROI formulas to work. Any idea why these are coming back as unparsable? Also how should they be? Formula 1: =IFERROR(IRR([Column2]28:[Col…
So I have a column I am trying to get a count of by year for a Metric dashboard. I am using the following formula: =countif([Completion Date]:[Completion Date], ="2023"). This formula is not working a…
I am trying to use a hidden field as part of my logic when I try to create a form. However if you hide the field, then it unavailable in the selection field. Any idea as to how to get it to work witho…
It would be a great addition to be able to transfer not only files from one user to the next but also any and all file and folder hierarchy structures they have as well. Even if it is nothing more tha…