-
Need to add on if "Yes" leave blank to my formula but cannot get it to work
Hi, I have been assigned smartsheets and am trying my best to train myself via youtube + the forum. I created this formula =IF(ISBLANK([Completed Date]@row), "", IF([Completed Date]@row > [END]@row, "No", "Yes") It shows if the completed date is blank: leave blank if the completed date is greater than the end date put no…
-
Formula to see if completed date is within the last seven days of the final acceptable date
Hi, I have a due date (which is a guidance), and then a final acceptable date. I would like to see what items are completed on the last 7 days (including the last day) of the final acceptable date. If it is completed in the last 7 days of the final acceptable date it will be "yes" , otherwise blank. Any help would be…
-
Summing values
Folks, I am looking for some help here. I am trying to calculate a value when the following conditions are met: If Billable = "Yes" AND Sprint = "Sprint 01" THEN SUM VALUE(Cell different sheet)/SUM ESTIMATES (this sheet where above conditions are true)*ESTIMATES value this row I have played around with multiple different…
-
COMBINE FORMULA TO LOOK UP 2 DIFF SHEETS
I need formula that will look at 2 sheets with different criteria but return field ops when a match is made. Sheet A might not have a match but sheet B does... and vice versa or Both sheets has a match and I need the " field ops to return in 1 column =IF(COUNTIF({Field Ops Invoice Tracker Invoice}, [Invoice No.]@row) > 1,…
-
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…
