-
Returning Task Name based on a MIN(COLLECT(range, criteria_range, criteria)) formula
I am trying to get the task name of the current milestone to populate a cell so I can use that cell in a dashboard. I have a helper column that counts the number of days until due, and can get the lowest number in the range that is >0, no problem. How can I return the Task Name of the row that I find my lowest number > 0?
-
Method/formula to rename sheets, reports and dashboards in a folder
Have a folder with 15 sheets, reports and dashboards used as a template folder. Titles include (Clear) as a generic placeholder in the folder and used in the 15. When a new project is started, we "Save As New" that folder, replace (Clear), with the project folder name and do so for each associated sheet, report and…
-
find and replace text in an already created update request.
I have update requests set for each employee's annual review. I would like to change one bit of text in the preformatted email. Is there a way to do this? Specifically, the line reads: Contact Mary Beth or Jesse. I would like to remove 'Mary Beth or' Is there a way to do this without opening each request individually and…
-
Generate reference after box ticking
Hi all, Been trying to look for my solution here, but i can't seem to find it. Hopefully someone can help me. I have a supplier approval database with supplier info, several checkboxes for required docs, etc. Also have an approval column, and then an approval reference column. What i intend to do is, when i tick the…
-
Using a modifier to derive month (formula de-bugging help
Ok. so I've set up a rolling dashboard built around the today function - something like this. Everything rolls over automatically as it all references TODAY() to determine the various derivatives. (see screenshot) It's great, but doesn't scale (yet). The Month column uses this right now - =IF((MONTH(TODAY()) + Modifier5) >…
-
Populate % Complete when Actual End is a date
I want to populate the % Percent field with 100 when the Actual End Date is entered. I tried this formula but I get an error. =IF([Actual End Date]@row > "0", "100", "0") Any suggestions?
-
If multiple cells are not blank - check the box
I figured the formula to check a box in a column if one other column is not blank, but I can't figure out how to check the box if multiple cells within a range are not blank. I'm using this formula: =ISBLANK([Monday | Start Time]1) = false I have a form that feeds into a sheet that has options for meeting start time,…
-
Count of Completed Tasks by Month across multiple sheets
I am trying to get a count of completed tasks by a team by month across multiple sheets. I've created this formula in the sheet summary: =COUNTIFS(Status:Status, "Complete", [Team Assignment]:[Team Assignment], "Lean"). If I'm trying to get a completed count of tasks for the month of September, how could I get that count?…
-
Struggling with INDEX and MATCH
Hello, I am trying to automate task assignment using the INDEX and MATCH functions. My formula is as: =INDEX({Order Sets Team Contact Roster Assigned To}, MATCH(Role@row, {Order Sets Team Contact Roster Role}, 0)) It seems to work for one role but produces a no match error for the rest of the roles. Please see attached…
-
Slow in loading the conversations/comments
I noticed ever since they updated the conversations/comments. The panel now shows on the right side instead of the usual pop-up. It's been slow to load. I thought it was just my pc that is slow but any pc I use have the same result. My tablet loads faster for these conversations to load.