Formulas

Hi, I am trying to create a sheet from data that is originally held in .csv files. My goal is to make it so that transferring the data to my sheet should be as simple as just copy and paste. My issue is that two of the fields that I need to copy over are reported in scientific notation (1.3E+004) and I am trying to figure…

Problem: Current Limitations Scale Conflicts: Currently, users cannot easily plot two data series with vastly different scales (e.g., "Budget" in millions vs. "% Complete" in decimals) on the same chart; the smaller metric becomes invisible. Complex Workarounds: Users are forced to create "Helper Columns" (to manually…

Good morning! I am having a difficult time using a formula to assign multiple contacts. I have the checkbox selected to allow multiple contacts, but it seems as though when it comes to a formula, the cell is only seeing it as text. Example: Cell1 - megan@test.com Cell2 - jones@test.com Formula: Cell1 + Cell2 This then just…

This may be a longshot, but I am wondering if there is an easy way to track what a delay is within a project? My best thought would be to make it a manual field within sheet summary that is a dropdown. It would be called something like Project Delay with dropdown selections like: Customer, Supply Chain, Sourcing, etc. Not…

I'm working on a project where I want to reference the contact list field in an automation email body, but it only pulls the Name field of the contact list item. Is there a way to get just the email address or does anyone have a good workaround for this?

@Paul Newcome I have 2 worksheets; Master List of site locations Tracker This worksheet pulls in some data from the Master List, i.e., site name, site address, site contact, etc. using and INDEX/MATCH with the 'Site #' as the unique identifier When the Site Address updates I want an alert to 'send to everyone shared to…

Hey guys, As per the question title, I'm trying to delete a Level 2 child row itself, indented under a parent When I do this, it deletes all the milestones, project plan data below it :( When I ask Smart Assist, it says it is safe to do so without losing any data - but having done this manually it deletes everything and I…

I am currently using the formula below to auto-create IDs based on the Module, Subworkstream and RAID Type of each item in my sheet. The problem that I am having is that if the RAID type changes, it resets every ID in the list. How do I prevent that from happening? Hoping for some guidance. Thank you!!! =[HELPER COLUMN:…

This discussion has been merged.

How would I go about writing a forumula to calculate the numbers of volunteer hours for a specific month and location. For Example: I'd like to know how many Total volunteer hours Lebanon - ED1 had for the Month of August. Thank you!