-
COUNTIF, CHECKBOX with CONTAINS BRANCH "MIL"
Hello, Please help and thanks in advance. I am trying to Count all the Key-User cells with a checkbox where the branch is MIL. I have tried the below formula but keep getting #UNPARSEABLE. Formula I tried is =COUNTIF([Key-User]:[Key-User], =1), CONTAINS ("MIL",@cell,[Branch;Branch]) Also tried…
-
Update Request
I am curious if an update request from can be sent out via text message? We are using the update requests for mileage and hours on our trucks and welding machines. Right now I have it to automate when dates are reached and then an email sent out for the pertinent information. Just thinking a text could be super slick…
-
Editing Formula
Hello, I have a formula that calculates the current month's total of an item. I need a new one that will filter by a specific month/year when edited to do so. How do I update this to do that? =SUMIFS(Spent:Spent, [Areas of Project Spending]:[Areas of Project Spending], @cell = PERSONNEL@row, [Expense Date]:[Expense Date],…
-
Manually enter dates in a column that has a formula?
Hi, I created a formula (with SS Community's help- thank you) for a date column that works great for what it was intended for. However, I now realize that date column also needs to be able to be changed manually. Is that possible - to have both a formula create a date but also be able to enter one manually? I saw some talk…
-
Parent row in report
Hi i have a sheet with ~2000 rows and ~1200 tasks. each task is assigned to worker. the worker need to see only the culomn that i choose in report and update only one checkbox column. the issue is that i want to display to worker the parent rows... and in report i not assigned the worker in parent row.... ony the specific…
-
Update Requests - Displaying (via Reports or Dashboard)
Does anyone know if there's a way to Display Pending Update Requests? We're using a lot of automation to send out Update Requests to team members, and I'm concerned that they're going to get lost in emails. It would be great if I could build a report, dashboard, etc. that showed all the Pending Update Requests. Mike
-
Multiple checkboxes automatically checked from one checkbox.
Hello, What formula would I use to have all of the checkboxes in the Ann Arbor Terminal 1-5 columns checked, after checking the prior "Ann Arbor Payment Terminals Inspected" column? Basically I'd like the checkbox in this column to when checked, trigger the other columns in the same row to be checked (without having to do…
-
How to calculate how many days left for the month?
what formula to use that will automatically calculate how many days are left till the end of the month? E.G. till the end of November months there is left 12 days. so mo column can show those remaning 12 days
-
Displaying multiple milestones on a single line in Gantt view
Hi there, Is there a way to display multiple milestones, denoted by diamond symbol, on a single line when it Gantt view? It would be useful when tracking multiple projects if there was a way to have a visual overview of key stages in one place without each milestone for each project being displayed on separate lines and…
-
Help with a formula!
I have been using this formula in various sheets to have a specific date pulled, depending on if a certain field is blank or not. It has been working fine, but all the sudden is now throwing a "blocked, circular dependency error." Any help is greatly appreciated. Attempting to check if the revised due date column is blank,…