Need help with some formulas Important Columns : Schedule Health, Status, Target Start Date, Target End Date Schedule Health will hold the formula - changing to RED GREEN and YELLOW Depending on formu…
Hello community, I am currently a little stuck trying to figure out what formula to use for the "days remaining before conference" column. I'd like to have a number there to know how many days are lef…
Hello! I'm having trouble with a formula in a sheet summary field. I have a column called "Service Type" where I want to count the number of entries that contain QA. There are multiple QA entries, som…
Hello! I'm looking to use a formula that will calculate the percentage of tasks completed by row based on whether or not the check box is "checked." I have five check box columns, so if one is checked…
I work in a property mgt department and we've built a room inspection form. Our suites have rooms assignments based on the bedroom within the suite. The columns for the form are broken into sections o…
I'm trying to create a formula that will display the different colored dots in the status bar. I had success at first but one part of the formula isn't working with the others. I need it to display BL…
Hello, The Status Column has a dropdown menu with multiple options with the text "Completed" and some other options: Completed awaiting Signature Completed Reviewing Completed Approved Failed Inspecti…
Hi, I have a sheet which has 1 column showing a document name, and another column for document revision number. I need to make a vlookup which returns the owner of the doc, based on the document name …
Good morning, I have a contact column, then an email address column where I use a Vlookup function to go to another sheet and pull the users email address from. However, when I enter multiple contacts…
Hello Community, I'm running into a bit of an issue. My previous worked fine for the year 2022 but now that we're in 2023 I need to adjust my formula to account for the year change. Below is the formu…