Hello, I am having some inconsistencies with turning VLOOKUP function into a column formula within the same sheet, I am using VLOOKUP in three different columns. One of the columns allows me to turn i…
Count the total number of checked boxes in the children rows of [Completed] and compare that number with the total number of checkboxes using concatenated text. Your answer should look like this: "Tot…
Hello, I am using the attached formula to try and ensure that I can expand the formula (currently has a 1:1 from a Project plan with RACI into a RACI Matrix with tasks associated to users) so that rat…
Hello, I have an issue I have been trying to find a work around. I need to find a way to track or verify the alerts that go out based on the many many different automations I have setup. The alerts ar…
Hi everyone, I'm currently working on a way to leverage formulas and row hierarches to create a ROW ID column. Essentially what I would like to happen for children rows to have the same "item ID" as t…
Afternoon All - I have a slightly complex question I wanted to pose to the community to see if I could get some thoughts. I have two sheets that I want to have "talk" to each other. One Sheet (Master …
Even after I have set the column property to Text and saved the sheet, the next time I access the sheet, the properties have again reverted to Date. Any ideas on how to correct this?
Sorry I don't really know how to phrase this. Basically in the projects we have, we get a quote from a vendor, and they automatically enter it into our project sheets. Because this can change to a low…
I have a sheet that has a column for each day of the year. I go in each week to hide the previous weeks columns, but still displaying the rest. However, since 3/21 the columns are no longer remaining …