-
Multiple IF AND ISBLANK Criteria in Formula
What I'm trying to accomplish: If [Approved] is checked, change [Status] to "Complete" If [Ad RSS Link], [Subject Line], and [Done] are not blank, change [Status] to "Proofing" If [Ads Entered] is checked, change [Status] to "Proofing" If none of the above are true, [Status] will be "Waiting for Information" Here is the…
-
Cell Linking issue between Intake sheet & Summary sheet (Control Center)
I have an Intake sheet that is tied to Control Center with about 20 links to a Summary sheet, that is part of a blueprint. At the moment we have almost 400 records on the Intake sheet. So I it appears to be about 8,000 links on the sheet. I am having issues with the cell linking not working if the Intake record is updated.…
-
Replace blank values with 0 but leave non-blank values alone
Hello all, I have a sheet with numerous columns that contain dollar (USD) values. Many of the rows have a blank value in these columns, and I would like to change those blank cells to be 0. I was hoping it would be as simple as highlighting the column and using "Find and Replace" to replace all blank values with 0, but I…
-
Multiple IF ISBLANK NOT formula
What I'm trying to accomplish: If [Approved] is checked, show [Status] as "Complete" If [Ad RSS Link], [Subject Line], and [Done] are not blank, show [Status] as "Proofing" If [Ads Entered] is not blank, show [Status] as "Proofing" If all of the above are not true, show [Status] as "Waiting for Information" Here is the…
-
Is it possible to display data from another sheet in sheet summary?
Hi there, I'm trying to create a Sheet Summary in a sheet and in one field I want to show the content of a cell which is in another sheet. Is that possible? Thank you in advance!
-
Referencing one sheet with date ranges to change all SUMIFS and COUNTIFS at once
Hello! Every month we update multiple project items once the previous month of data is collected. Up until now, we have gone into each projects metric sheet to update, changing the date range to pull the recent data. Instead, I would like to build one reference sheet, populated with every day of the year in 12 month…
-
Can you see real time comments in Dynamic View?
I have gotten this question a few times and the problem that we have run into is that when we type the comments in the Dynamic View comment section, we are not able to see it after we hit submit. The only way we know that the comment was saved is choosing another row and come back to prior row, then we are able to see the…
-
Percent complete is showing more 100%
The formula works, but it is still calculating after the finish date is met. How can I stop that from happening? Below is the current formula I am running. =IF(ISBLANK([Estimated Start]@row), 0, (TODAY() - [Estimated Start]@row) / ([Estimated Finish]@row - [Estimated Start]@row)) Thank you,
-
Is there a way to count the number of CHILDREN in a column?
Hello, I am trying to count the number of CHILDREN I have on a single sheet in my Primary column in order to output the total number of projects we have. My hierarchy in my in my Primary column is "Project Manager" (PARENT) and then "Project Name" (CHILD). I want to count the total number of CHILDREN in that column, but…
-
Multiple IF and IF (AND) arguments in one formula
Does anyone see any obvious issues with this string? I'm trying to pull from two columns [VA Feed status], [QA Feed status] and output one status based on the column statuses. This is a combination of IF(AND) and also just IF statements. I'm currently receiving #UNPARSEABLE =IF(AND([VO Feed status]@row = "VO: Pending file…