-
IF function, dates, and late/on time
Hi! I'm trying to figure out how to write a formula that will show whether a task was completed on time or after its due date. Here's what I tried, but it didn't work: =IF([Completion Date]17<=[Due Date]17, Yes, [No]) I'm trying to say if the completion date is on or before the due date, populate the cell with Yes (on…
-
Total Amount of Rejections Created Last Week
Help!!!! I can't figure out where the problem is with my formula. I am trying to write a formula to calculate the total $ amount of rejections from last week. This is what I have. It comes up with an Incorrect Arugument. @Paul Newcome can you help?, please...... 😀 =IF(WEEKNUMBER(TODAY()) = 1, SUMIFS({Rejection Tracker…
-
Formula to include verbiage based upon selection
Hi all, I am working on a sheet in which I need a formula that when a status is selected in one column that additional verbiage would pre-populate another column. The picture below in the status column, when I select the word "cancelled", I would like the comments column to show the word "event is not going to happen" I'll…
-
Need some help from my Smartsheet Formula Experts!
I need to count how many times a reject appears on my listing that reject and appear on my reject listing again. This would actually result in a duplicate second row on my sheet with a new create date. All other data would be exactly the same. It most likely would have a different week number. How would I best be able to…
-
ISNA Excel Formula
I am trying to recreate an excel formula in Smartsheet that looks for the column Header word in the proceeding columns within that same row. If it finds the word in that row, it then places the word in the cell that the formula exists. So if the formula is in [Apple]1, it searches a specific range of columns in row 1 for…
-
countif by date references
I have a column of dates in one sheet called {Dates} In a second sheet I want to analyze the dates based on if they fall into a specific calendar month I have a column called Y (year) filled with data like 2020, and a column called M (month) filled with data like 1 (i.e. January) using the following formula:…
-
Help with counting # of items that have start dates between X and X date
Hello, I can't seem to figure out how to get a count of all items with a start date between 5/4/20 and 5/8/20. This will be used as part of a COUNTIFS formula if that helps, I was able to get the first two criteria in but can't figure out the dates. The start date reference column is in another sheet and each cell only…
-
If then formulas
I am trying to create my own easy work around to capture the date when something is completed. IF the Completed Box is checked AND I have a last modified date column Can I create a date completed box and say IF the Completed Box is checked, then copy last date modified? =IF(Completed1,1, [Last Modified Date]1, "") Does not…
-
Can you auto populate task dates based on the entire project end date?
I have different marketing tasks where their completion dates revolve around an entire projects completion date. For example, there are tasks that need to be completed 10 days before project completion date, 20 days prior, 30 days prior, etc. Is there a formula I can use that auto fills task due dates based on the project…
-
Complex formulas ammendment
Hi All, I have an existing Smartsheet that has some relatively complex formulas to count the the status of an action as there are several conditions for an action to show as "Open" and "Overdue". Over the last few days, we have modified the sheet further by adding columns and each added column now comes under as added…