Jared Ross
Jared Ross
Discussions
- I used to be able to copy a number of files in a finder window, and paste them into a column and have them appear in multiple rows as file names. Recently, it started pasting them in as an image in a …
- So I'm fully aware of the automation to add a date when a cell is changed, but it doesn't seem to be working for me. Hoping someone might point out where I went wrong. I have a grid of teams and membe…
- Posted this last week, but it seems to have died on the vine. I Regularly refresh different databases throughout the year by making a copy of the old one and importing the new data into it. This resul…
- I Regularly refresh different databases throughout the year by making a copy of the old one and importing the new data into it. This results in a ton of redundant data, and I'm looking to quickly cull…
- I have a sheet that I'm trying to find metrics on based on several different columns. CONFERENCE TRICODE ID_CHECK There's roughly 30 conferences with roughly 15 tricodes within each, and a dozen or tw…
- I have a master progress sheet for a project with a bunch of different projects. To track my own progress on another part of the project, I've created a PRODUCTION sheet, as parts of my task don't nee…
- So I'm looking to create a widget that quickly shows me the number of times a value is represented. What I want to do is separate out a number of teams I have and see how many times each team has a "m…
- So I'm using the following formula and getting errors. =IF(COUNTIF([ID Dump]:[ID]), "CURRENT", "NEEDS") Basically, I'm trying to get a return of CURRENT if any of the values in the "ID DUMP" column ar…
- I am pasting in a bunch of file names into a column (ID_Dump) and need to remove the extension ".png" from the cells. How exactly would I accomplish this? Also, not sure if it makes a difference, but …
