-
Red, Yellow, Green, Gray automation formula help needed for numerical ranges
I have a column called "Resource Totals" and I am trying to create conditions for the status column (Already made it a symbols column) for Red, Yellow, and Green Green = 0.9-1.1 Yellow= 1.2-1.3 Red = >1.3 =IF([Resource Totals]@row = "0.9-1.1", "Green", IF([Resource Totals]@row = "1.2-1.3", "Yellow", IF([Resource…
-
Formula not working
Hello, can you explain this error to me? The formula returns me the value 0 for a project that lasts one day Thank you
-
Index Collect formula?
I am trying to collect information from a combination of 3 sheets. Job Duties is a multi select on employee Database Crew is a multi select on job log Vehicle is multi select on job log Driver on asset summary sheet would pull in Driver(s) from the job log based on the vehicle. On the Asset Summary Sheet, I’m trying to get…
-
Formula to count media in market
Hello, I'm looking for a formula to count media based on their date range. 1) Count media where date range (start & end date columns) are in the PAST 2) Count media where date range (start & end date columns) include TODAY 3) Count media where date range (start & end date columns) are in the FUTURE I believe I have 1 & 3…
-
How do I populate the highest parent level data into another cell?
I'm using the '=PARENT([Primary Column]@row)' formula, but it's populating data from the parent row, even if the parent row is a child of another parent. I need to populate in a separate cell data from the highest level parent row. In the example below, is there a formula that would populate Primary Column row 1 data,…
-
How to avoid circular reference?
I am trying to sum purchase orders based on where the items are coming from. =SUMIFS([Bag - 55 Gal Trash]:[Bag - 55 Gal Trash], [Were these provided by the Warehouse or Job?]:[Were these provided by the Warehouse or Job?], "Warehouse") =SUMIFS([Bag - 55 Gal Trash]:[Bag - 55 Gal Trash], [Were these provided by the Warehouse…
-
CountIf Date formula compare different date columns
I have 3 date columns: Start Date, Draft Due Date, Final Due Date The date columns are all initially auto-set to the same date; professionals are to subsequently update the Draft and Final due dates to a later date. I would like to count the ones that never get updated, i.e. Draft Due Date = Start Date. By the filters…
-
Harvey Ball formula with Expiry dates
Hello, I am going crazy, I have been through the community posts and tried to figure out this myself with no success. I want a Red ball to appear if the date in the CV Expiry Date column is less than a week away, or in the past. I want a Yellow ball to appear if the date is in the next 30 days, and Green if it's more than…
-
Is there a way to count cells that contain dates in Smartsheet, like Excel's COUNTA function?
-
Multi Select Look up
I'm trying to see if anyone has any ideas of a formula that can been written for the following example. I'm trying to get the contact(mail) in sheet 2 to populate sheet 1(Approval Seq 1 Contact) column. There is 2 criteria (Division and Seq.1) on sheet 1 need to match (Division, Sequence #) on sheet 2 to return the contact…
