-
Health Icon Formula Help
Hi All - Longtime lurker, first time poster. I am attempting to add a Health Column to a smartsheet created by a colleague. I have been in the forums checking answers to similar, and tried to kluge my own formula together, but I've either missed the logic or I'm trying to do too much. What i'm trying to achieve rollup…
-
IF formula: IF x in column A then enter this in this column B
Hello All, Need some assistance with an IF formula. I want to create a formula where each month in a row is accounted for and assigned a Quarter. Q1 ( January, Feb, March), Q2 (April, May, June) Q3 (July, August, Sept) Q4 (October, Nove, Dec). Below is a part of a formula that I have come up with - let me know your…
-
In Progress Formula Not Working (Also Start Date Not Adjusting)
Hello, We had a project template set up for us that would automatically provide a status of "In Progress" if the % Complete was not 0. I made the % Complete 10% for one of the tasks and the parent didn't pick it up, so the status did not move to "In Progress". Here's a screenshot of the task being 10% complete and the…
-
I need help with formulas
I am working on formulas to get approvals in one of my sheets - But there are more than 2 options and I'm finding it a bit confusing… IF both directors APPROVE = Trade Off Accepted IF one director APPROVES and the other one is PENDING = Pending Acceptance (Would I need two of these?) IF both directors REJECT = Trade Off…
-
Parent rolling up data in Children rows
Green line is the parent row everything inbetween is children rows Column 30 is counting rows from N/A column that are not ticked, which are the rows im looking for. so 6 rows are active rows which are being used. out of the 6 rows, 4 rows have been ticked in appoinment concluded column i want to roll up the count of 4 in…
-
COUNTIF FORMULA WITHIN DATE RANGE.
Hi All, I get invalid operation for the following formula. Any ideas on my error? Trying to count the number of times something appears in a column within a date range. Any help would be great please. Thanks. =COUNTIFS({TIME RECORDING}, ([Column7]@row), AND(@cell >= DATE( [Column6]2), @cell <= DATE([Column6]@row)))
-
Formula to Count Ages of Orders
I'm trying to create a formula that counts the open orders based on the date the order was created. The thing complicating the formula is that it's for a metrics dashboard, so I need it to count the orders that are between 1-3 months old, 3-6 months old, 6-9 months old, 9-12 months old and over a year. I'm at a complete…
-
Pulling data from one form to another
I am creating a sheet that will collect data from multiple regions through a specific contact. I currently do it through automation. When I fill in a specific region the email associated with this region is in the automation that I created and it populates the particular cell, and sends a form to that person. I am…
-
COUNTIF and HAS
I'm trying to use Sheet Summary fields to determine how many people have signed up to work a football game. The Sign Up columns are multi-select dropdown, and I feel like I've done this correctly, but it returns the answer of 0, despite my having 2 instances when they should be counted. Any thoughts to remedy?
-
CONTAINS or HAS formula extension
Hi community, I am looking to extend either a CONTAINS or HAS formula to pick up a dropdown value from one column and assign it a numerical value in a separate column. Can anyone assist in what is the most effective way to do so? The intention is when any value from the "Suburb Population" column is selected via dropdown…
