-
Some issues with this function (Countifs with Weeknumber)
We are using the below formula to count how many people are "Complete" during the current week. It was working yesterday, and earlier today but has now stopped working and I am unsure what caused it. The only changes were just adding additional rows to next week's totals, but the value continues to show 0 for this week…
-
Sum of Cells when another Cells Fall In a Certain Date Range
Hello Smartsheet community! I have a sheet that has a column for a Delivery Date, and another column for the Qty of items to be delivered. Delivery Date - Column A Qty of Carrots - Column B I need to put together Summary Data to know how many Carrots are needed for a specific date range, example the month of June? Thanks…
-
How to subtract a month and have it be the same day of the week of the month.
I have a bunch of dates where I would like to subtract one month, but need it to be the same day of the same week of the month. For example, if the date is on the second Thursday of the month, then the result should be one month prior, but also on the second Thursday of the month. However, my dates are all on different…
-
Profit percentage calculation
Hey all. Trying to get a profit percentage formula. Columns are: "Price Bought" "Price Sold" I want to get the profit between the bought and sold, so if I bought for $1200 and sold for $1000, that's 20% profit ($1200 / $1000 = 1.2) What's the correct way to do this?
-
Formula assistance
Hi, Could someone please help me understand why my formula doesn't work. What I am trying to achieve is: IF today's date is between the CI Start & CI Finish, then return "Consultants Inspections" IF today's date is between the BSI Start & BSI Finish, then return "Building Surveyor Inspections" IF today's date is between…
-
Parent with Left & Find
I'm trying to create a column formula that will populate with the leftmost word in the Parent column. I know this formula works: =LEFT([Task Name]@row, FIND(" ", [Task Name]@row) - 1) But when I put PARENT in front, it comes back as #UNPARSEABLE =PARENT(LEFT([Task Name]@row, FIND(" ", [Task Name]@row) - 1)) What am I doing…
-
Multiple if statements combined into 1
Hi, I am trying to create a formula to update the status column. If ALL 5 people columns has any combination of "approved", "approved: with questions", "approved: with comments", then it marks the status Approved. If any of the 5 people columns has "In Review" or Reviewed: with questions", the status column in mark as "In…
-
COUNTIFS help
I have this formula but its's not counting correctly. I want to show a count of the Date Received column that have been delivered. =COUNTIFS({Gear Ship Schedule Template Platt Item}, AND(@cell <> "Qty", @cell <> ""), {Gear Ship Schedule Template Delivered}, <>"")
-
Date formula / duration question
Hi there, I have a Start Date column, an End Date Column, and a Duration (days) column. When the Start Date column is populated, I'd like for the Duration (days) column to count the number of days between start date until today. Only once the End Date column is populated, would I like for the Duration (days) column to lock…
-
Formula to create visual indication of a cell link in a row
Hi all, I would like to display a symbol in a column of a row IF a specific cell in that row is being used as a cell link to another sheet. I know that a small black triangle appears in the bottom right corner of the cell if it is linking to another sheet, but I would prefer a much larger visual indicator if that is…
