-
How To Use Formulas with Symbols for Sales Sheet
Hello, I created a sales projection vs actual sheet for 2021, I would like to use a formula with symbols to automatically change based on percentage. So if it's at 25% one, 50% one, 75% another, and by 100% show green, based on my column names, what would be the best setup for the formula? I greatly appreciate your help.
-
Simpler way to convert High/Medium/Low symbols to score - without using nested IFs?
I am trying to "score" rows using Impact vs Effort columns. I know I can do this using a complicated nested IF statement. In google sheets, I can more easily use VLookup or Choose like this: =VLOOKUP(M4,{"Low",1;"Medium",2;"High",2},2,FALSE) / VLOOKUP(N4,{"Low",1;"Medium",2;"High",2},2,FALSE) or…
-
Trying to use SUMIFS function to count spend in 2020 by Firm
Struggling newbie here! For the life of me, I can not figure this out. I am trying to find the spend of each firm, and qualify it by the year so that once 2021 rolls around, I can track spend-by-year. I know the end of my formula below is wrong, but I cannot figure out how to qualify by formula by year. I've mastered the…
-
Need help with a formula that is using data from 2 columns
I have a column called Building Turnover and Scheduled - Days Out. Schedule days out takes turnover - today to get a number. I want to see the value and if the value is <30, I want to add 15, if it is I want to add 30. I want all of that in another column Can you help? =IF(OR([Scheduled - Days Out]@row1< 30, [Building…
-
Data Uploader Not Displaying Time from Import
Hello, I am using Data uploader to import data from an excel sheet. It is critical that we pull in the date and time from the sheet. However, the time is not being pulled in - only the date. So i went to the source excel sheet and extracted the into a separate column. I used the =TIME(HOUR(G2),MINUTE(G2),SECOND(G2)) and…
-
Parent/Children Flag Formula
Hi all, I'm trying to create a formula that will flag a child row if a certain date is within a # of number of days, but I'd also like it to flag the parent row if any of the children row are flagged. I am currently using these two formulas: for the parent row - =IF(COUNTIF(CHILDREN(), =1) > 0, 1, 0) . . . and for the…
-
If checked subtract using a date, if unchecked subtract using another date
Good afternoon, I am trying to create a day counter that will be counting until another date is filled. I thought nesting if formula's would work, but so far I am not successfully creating the correct formula. A screenshot below will hopefully help and here is the formula I wrote that is giving me the "Incorrect Argument…
-
Automated RYG Based on % Complete Formula Help
Hi, I'm trying to automate the RYG colored balls so they automatically change colors based on the percent complete entered. I watched a video, read through the suggestions from the community, and was unable to come up with a formula that worked correctly. Can you please help me identify the error in my formula? When I…
-
"IF" formula using dates and check boxes
I am looking to set up a count to see how many people are scheduled for an appointment verses how many have come in. I have an appointment date column and a check box that is clicked when someone comes in. I want this to be a summary formula not a cell. Could someone help? What I messed around with was…
-
Sumif matches criteria from multi select dropdown
Please help, i want to sum the Time Required in case the Week Number column has 1 and update Status is Monthly. I used this below formula but its not working. SUMIFS([Time Required (Hrs.)]2:[Time Required (Hrs.)]6, [Week Number]2:[Week Number]6, HAS([Week Number]2:[Week Number]6, "1"), [Update Status]2:[Update Status]6,…