-
Adding YTD totals without using Sheet Summary fields
I have a sheet the tracks manufacturing operations. Each year, I need to summarize YTD totals from the sheet. This is resulting in many sheet summary fields each year. As time goes on, I will run out of the limit of 200 fields. Is there a way to automate any of this, either with automation or having information go to…
-
Dynamic view time-stamp issue
I am set up in CET, and I set up a dynamic view where the time stamp column (time created) in the sheet is transposed to the dynamic view with a +6 hrs. This is kind of inconvenient… is this an issue that can be resolved? e.g. 12:01 pm appears as 18:01 in the dynamic view vs. 12:01, 11:40 am appears as 17:40 in the dynamic…
-
Creating child rows with form selections
Newbie here! I have created a form for marketing requests. One of the drop down fields is for Marketing Avenues with 13 possible selections. I would love to find a way to auto create child rows for each avenue selected under the parent project row so we are able to assign those to different people and keep up with each…
-
Control Center Links and updating from report
I am using control center to create new projects and folders and linking to a Summary sheet. However I want to be able to create a report from the summary sheet and make updates to fields that will post back to the summary and the project. Is this possible? currently no matter what link option I use in the profile setup it…
-
Flag projects at risk
Hi community experts, I'm trying to flag projects that are at risk. A project should be marked "At Risk" if the Status is not Complete, the Due Date is within the next 7 days, and the % Complete is less than 80%. Otherwise it should show On Track. What formula can do this?
-
Alert when all proofing feedback has been received
Would be great if an email alert can send out to the person who invited users to review a proof for when "all" feedback has been received for when you have multiple people reviewing the same proof. This way as you receive feedback over email for when a user clicks to "Approve" or "Requires Changes", you don't have to keep…
-
Trying to Eliminate Unnecessary Automated Announcements
I have an active automated notification in a sheet of project tasks that lets the "assigned to" know when anything has changed in their row. However, they don't need to know about changes they made themselves so I am trying to eliminate those. I set up a column called "MATCH" and added a formula to check for a match…
-
Creating a formatted/merged email from a grid
I have a complicated workflow that I'd like to significantly reduce, in terms of time spent. Working from a standard grid, I need to format the email, pulling some summary information for a project and then adding specifics for each individual tied to each project. A few points: the summary information is currently in a…
-
Complex Automation
In a sheet, in the primary column (Task Name), I have multiple parent rows with all of the same child rows beneath each parent row. A simplified example is each Parent Row is a new lot number, with two associated child rows called "Date of Shipment" and Date COA". There is also a drop down Status column. I want to create…
-
Conditional Formatting in Rows Resulting from Formulas
Hello, This might be somewhat of a long/confusing one. I am trying to figure out how to better automate categorization for blood pressure categories when being placed into a sheet. For example, in the image below the column "BP" is where the initial number is input. I then put a LEFT formula in the column "Sys formula" to…