Formulas and Functions

Archives for January 2019

Discussion List

  • Please help with a formula!
    In Formulas and Functions
    I am looking to compare Year to Date numbers, and I'm having a hard time figuring out a formula to do so. I've attached a sample screen shot. At the end of the day, I'm trying to add a metric into a dashboard that shows 2018 vs 2019 year t…
    11 views 5 comments Most recent by belliott76966 Formulas and Functions
  • Calculating Awarded Estimates
    In Formulas and Functions
    I have a running list of estimates we submit. when we are awarded the project that column gets checked. im looking for a way to scan the entire column and report back the percentage of estimates we have been awarded to the total number we …
    1 3
    1 view 3 comments Most recent by Mike Wilday Formulas and Functions
  • Flag as At Risk if Due Date in Past and Complete = X
    In Formulas and Functions
    Hello, I'm looking for support on what formula to include in the Flag symbol column that would act against the following: If Due Date is in the past and Complete = X (Visual Symbol), then flag At Risk column with Red flag Currently, usin…
    71 3
    71 views 3 comments Most recent by Mike Wilday Formulas and Functions
  • Returning Data with a formula
    In Formulas and Functions
    Boy have I gone round and round with this!  This formula is meant to bring back the data from another sheet based on the code entered (ie: code - CALVE and it should return the full name, email of that company from a different sheet).  Som…
    11 views 3 comments Most recent by Paul Newcome Formulas and Functions
  • COUNTIFS formula using dates excluding weekend days
    In Formulas and Functions
    I'm trying to figure out the correct formula for counting up the # of entries for a particular location with a "YES" or "NO" data entry for the previous date, TODAY (-1), that doesn't include weekends.  For instance, i…
    214 11
    214 views 11 comments Most recent by Andrée Starå Formulas and Functions
  • multiple If AND/OR statements
    In Formulas and Functions
    Spent a lot of time on this and I'm sure I'm just missing it so if anyone could help, I'd appreciate it.  I'm trying to create a formula where it will check a box if either one of these 2 scenarios happen 1)  If the [Sales Admin CRM Remov…
    173 4
    173 views 4 comments Most recent by Paul Newcome Formulas and Functions
  • "\" Character in String
    In Formulas and Functions
    Forum Id like to create a formula that mirrors 'Concatenate' from Excel, so Id like 3 items concatenated; 2 sources from 2 columns on my sheet and the third is a manually written in text string with the formula itself: Column A Tet …
    31 7
    31 views 7 comments Most recent by Mike Wilday Formulas and Functions
  • RYG Status column, IF/AND/OR formula help
    In Formulas and Functions
    Hello Community, I'm trying to establish an RYG Status column formula in my sheet based on values in three other columns. One is a STATUS column with drop-down selections of Completed, Not Started, In Progress. The other two are date colu…
    474 2
    474 views 2 comments Most recent by EricMart Formulas and Functions
  • the Right formula to make the date change every day
    In Formulas and Functions
    Hi,  What is the way to make date change every day automatically and also I do not want the dates of previous operations to change, I just want to change dates for new processes, is there a formula for it? For example, in the Excel  there…
    1 1
    1 view 1 comment Most recent by Andrée Starå Formulas and Functions
  • Reference a Report
    In Formulas and Functions
    I am using a form to track time spent on projects. Right now, they select the project from a dropdown list that I manually created and then they type in the task and the hours worked. Ideally, I would like for the Task Name to populate ac…
    313 6
    313 views 6 comments Most recent by Paul Newcome Formulas and Functions