Hi all, I have a sheet that contains hierarchy, I needed to make a dynamic view and maintain the hierarchy, which I partially achieved with formula columns. Long story short, I have a parent cell (pro…
I'm trying to calculate data from a status column that has drop down options of 'in progress' and 'not started' and see how many from those 2 criteria return an end date up to the end of June 2024 (wo…
Hi, I am trying to sum the number of individuals that are supported by a customer. There are several opportunities that support a single customer and within these opportunities the same individuals ma…
I'm trying to copy data from column to another, but only if certain conditions are met (i.e. if a separate column is checked or has a specific drop-down selection). I tried creating an automation with…
I am creating a table to collect total REPORT KEYS that are unique month to month for each dept, each division and with unknown total transactions in each report key (we don't need to know how many tr…
I have been doing a ton of research on how to do a dropdown at the CELL level, instead of column level. All signs point to this being a lost cause, as the feature has been being requested for 5+ years…
Looking to calc MQLs if FY = FY24 (easy part), but each region has a different conversion rate and that's where I'm struggling. My formula is something along the lines of: IF ([FY]@row = "FY24"), and …
Hi Everyone, I am trying to write a formula that will look at a cell and if certain wording is not in the cell then return a value to a new cell. The information is from a multiple dropdown selection …