Formulas
Discussion List
- Hi, I'm getting the below error message. My needs are too complicated to convert any of the formulas to automations and I'm not sure how to simplify. Here is essentially what I am trying to do - every…
- Hello! I was hoping someone can please point me in the right direction on this one. I created a Vlookup that will compare an ID number on a sheet that users will fill out via form, and return the due …
- I am looking to add to the formula so that if {APD CI Tracker Range 5}, ="Pilot/ Implemented" the Dashboard reads "Pilot" OR if {APD CI Tracker Range 5}, ="Monitor/ Check" the dashboard reads "Monitor…
- Hi everyone, Can you help me to figure out what is the correct formula to use in this case? I want to sum only the rows that have the following criteria: "Projected" or "General Foreman", or "Foreman"…
- I am trying to have my gantt chart show the visible %complete in number form rather than having the bar go then %length as it is much harder to determine how far along it is for shorter tasks. I was w…
- Hello there, I've already built a formula out so that it includes the Quarter and fiscal year, and it works great, however I was wondering if it is possible to make this formula include the extra 5 da…
- Hello - I am using INDEX/MATCH formula to pull dates into a sheet. One particular column is different because the dates can be in one of 2 sheets. What would be the correct formula? Current formula =I…
- hey guys, i need some help creating a formula that will pull through the amount of type A i have delivered month. Thanks in advance, Katie
- Hey guys, I need help to put a formula in my sheet that can sum all 'Type A' column that are from a specific campaign and specific market. for example all total of type A for Jazz (campaign) AT (marke…
- =IF(AND([Due date 2023]@row > TODAY(), ISBLANK[Completed 2023]@row), "yes", BLANK) This is the formula which I think is pretty simple but I'm trying to get a yes if the date from due date column is gr…
