-
Setting parent value based on multiple criteria and multiple columns of children
Hello community, Ive scoured the forums, and found some similar questions, but nothing quite like what I need. I'm new at this app and forum, so please advise if I make a mistake in how to ask properly. I have parent rows, with an unknown number of children underneath. I'm trying to automate the status of the parent based…
-
If/then statements and automation
Hi team, I'm struggling with a request. Not sure if it's a Friday burnout or not. I was asked if we could populate one column of a sheet with a value if it could change the value of a different column. Ex: when selecting a percentage complete value (0, 25, 50, 75, 90, 100), would like for value selected to populate Phase…
-
Using IF and OR to Assign a Contact
I am currently using the following: =IF(Line@row = "Apples", {Contact 1}), IF(Line@row = "Oranges", {Contact 2}), IF(Line@row = "Pineapples", {Contact 3}), IF(OR(Line@row = "Red Grapes", Line@row = "Blue Grapes", Line@row = "Purple Grapes", Line@row = "Green Grapes"), {Contact 4}), IF(OR(Line@row = "Pears", Line@row =…
-
Date-Time vs Date - Strange Behavior?
I noticed that if you neglect the fact that a date-time is not the same as a date, you get unexpected results. If you look at the image you see a date-time and a date column that is set to equal the column to its left. As you can see it does not produce an error, and it populates the date. However, only in certain…
-
Counting rows based on time created
I am looking to build a report based to count the no of rows created between a certain time, say 0800-20:00 for today with one condition. Tried all possible combination but no luck. Any help please?
-
Calculation Sheet for multiple sheets
Hi Guys I have a calculation sheet that is currently bringing in data from 3 external sheets in order to be able to create reports and graphs for dashboards etc My problem is that I am conscious I will reach my cell link limit, along with the fact that 3 or 4 more sheets will soon have to be included in calculations,…
-
Controlling Traffic Light Symbols Based on Comparison and Date Fields
Hello everyone, I am attempting to control the "traffic light" symbols, Green, Yellow, Red, based on a comparison of one field to another and a date range. Essentially it's a booking system where user inputs X and requests a date range. I'm trying to make it possible to book into the future and make my status symbol change…
-
Compare a Field if Column Can Contain Same Value More Than Once.
Hi All, I'm creating a booking system and think I am running into trouble with my formula because it's possible to assign the same value in a column more than once (so the formula doesn't know which row to look at possibly). Formula below. =IF(AND({DateCheckFlag}@row=1,[Asset Name]@row={DeviceName}@row),1,0) In my case, I…
-
Creating Reports for just the current month
Is there a way to create a report that only displays this month. I know there is a way to show X days in the past, future, etc. I have a formula in my sheet that shows the month number to be able to find the current month number, but I don't see the ability to display only that data?
-
COUNTIFS Resolved (or not) within 2 days over the last 7 days
I have the following columns: Date (I refer to this as 'Date Opened' below) Resolved (checkbox) Resolved Date Formulas in the 'Sheet Summary' section I am trying to create these formulas to reflect on the last 7 days, will be used to make a dashboard chart widget: Resolved on time (2 Days) over the last 7 days Count the…