This is my current formula for million but I need in billion. Please help thanks ="EGP " + LEFT([Total 2023]57, IF(MOD(LEN([Total 2023]57), 3) = 0, 3, MOD(LEN([Total 2023]57), 3))) + IF(LEN([Total 202…
We have a process where live jobs are created on a master sheet then moved to an archive sheet when finished. We have a number of other sheets which use VLookUps or INDEX(COLLECT) to pull required inf…
Hi there- I had a formula entered into my worksheet that would auto-assign a colleague to order requests based on what groups they did ordering for. Somehow the formula was augmented so that it no lon…
I have a multi select column "Cost Code." There are currently values in the column that are not within the dropdown list. For the "Accessory Code" I was able to check and flag these via the following …
Hello! I'm trying to write a summary formula to count how many projects have a Resourcing score of 8 or higher and the approval status is not "canceled." This is the current formula I'm attempting: =C…
Hello! I am creating one master sheet for a variety of portfolio metrics (we currently don't have control center - working on that!) and am having trouble figuring out the best formula to populate the…
I have this formula (below) to calculate my "Due in Days" column, and a conditional formatting rule that states "If due in days is less than 0" then apply a red font. but I'm wondering if I'm able to …
I have two columns with multi-select dropdowns. I would like to add a column that will sum the totals based on what is selected in the two dropdowns. Here is what I am trying to accomplish: Cost List …
Hi I just tested and found out that if I am keeping the Status field blank, then the SUMIFS() function is not processing that row. I have pasted below -- the Summary cell formula, and the results comi…
Hi All, I need help with an if/then formula. I am looking to put: if status = definite, then it will populate revenue from the total estimated revenue cell if status = actualized, then it will populat…