-
Please help with a formula!
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 to date. I created the "YTD" column that shows the value of the last column that has…
-
Calculating Awarded Estimates
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 have quoted to date. I would also like then to check how many awarded projects have…
-
Flag as At Risk if Due Date in Past and Complete = X
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, using formula below to flag At Risk column with Red flag based on requested due date…
-
Returning Data with a formula
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). Sometimes this formula works perfect and other times it brings back the wrong company? Can…
-
COUNTIFS formula using dates excluding weekend days
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, if today=Monday, then the formula would need to search for the previous Friday date and count the # of…
-
multiple If AND/OR statements
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 Removal Complete] date column is a date OR 2) If the [Reason for ITS] = "Obsolete Change…
-
"\" Character in String
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 String abc\123 [as an example] Column B I can use "+" or JOIN it seems, but the fact my text…
-
RYG Status column, IF/AND/OR formula help
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 columns START DATE, FINISH DATE. Here's the statements without proper syntax: IF(STATUS)=…
-
the Right formula to make the date change every day
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 is a option called enable iterative calculation, is there a similar option in…
-
Reference a Report
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 according to those available based on the Project selected. For example, if the user…
