-
Using a Logical formula to return a numeric value
I'm trying to use a logical formula to return a numeric value based on the drop down selection in another column. For example, if column X contains Tier 1, insert in column Y a value of 1 If Tier 2, return a value of 2 If Tier 3, Return a value of 3 This is the formula I'm trying to use and I get an unparseable error…
-
Is there a way to pull specific characters from cells that have inconsistent data?
I have a weird situation where I need to pull specific data from cells that don't consistently look the same. What I need the sheet to do is this: I have a column called "Room ID" that will have data that looks like one of the following: AB123 or ABC1234 and other variations. On the same sheet I have a column called…
-
Automatic hyperlinks
Hi, I've seen this topic going on since 2017. Is there a way now to turn off automatic hyperlinks (even if they are not hyperlinks)? If not, would it possible to give us a function that just simply turns a hyperlink into plain text? It's a clumsy workaround but at least it's a workaround. Has anyone else figured out how to…
-
Auto Assign Subtasks to mirror parent
It would be very useful if I had the ability to auto assign subtasks to be categorized the same as the parent task.
-
how to find out oldest item by status?
I have a table that has fields like following I need to create a metrics, that shows only the lines with oldest age of each statuses. How can i create such metrics?
-
Formula to count days past due but leave the column blank if the task is completed
Hello, On my sheet I have tasks that have a column for Due Date, Completion Date, and Checkbox for Done. I want to keep track of the tasks that are overdue and have an easy way to glance and see how many days they are over due from the due date. I have been successful in using this formula for that calculation =TODAY() -…
-
COUNTIF Excluding one Status
Hi, Please consider this below table as a scenario where while that I am counting the HR Type against Solution Type if the COUNTIFS formulae, I simply want to exclude "Complete" ones Below if the formulae that works without the project Status condition. How do I exclude for Complete =COUNTIF({HR Category},"B",{Solution…
-
Automation for Updating Metrics Data on Dashboard
I have data that rolls up into a Metrics sheet. I currently have metrics, by month, displaying on my dashboard The data is currently manually update, by month. Is there a way to automate the change in month, subsequently updating the data displayed, i.e. volumes?
-
Countifs and Isblank is not working
I am using a formula in a column, "Repeat Values" that checks another column, "Document Number", for repeat values and if there are repeat values it checks the checkbox in the "Repeat Values" column. This formula is somewhat working, but also checks the box for all blank cells in the "Document Number" column.…
-
countifs issues
=COUNTIFS({Incident Summary Form Range 1}, "Sioux City", {Division}, "utility", {Incident Summary Form Range 8}, AND(@cell >= DATE(2021, 1, 1), @cell <= DATE(2021, 1, 31))) This worked until i added {Division}, "utility", can someone tell me what i did