-
SUMIF value exists, leave blank if cells are blank (nothing to sum)
I'm trying to figure out how to create a formula to sum a column if there are values, but leave the field blank if there are no values in the range. Is that possible? Here's the background: I'm trying to create a status report that shows whether or not someone has actually entered values into the appropriate column. If…
-
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…
-
"\" 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…
-
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…
-
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…
-
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…
-
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…
-
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…
-
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)=…
-
RYGG Ball
Hello I have looked through the list of current Formula but cant find any that matches what I am trying to do (see below): If task due date is > 2 days from current date (today) AND Status is NOT STARTED or IN PROGRESS then flag the Green ball If a task due date is < 2 days from current date (today)AND Status is NOT…
