-
Vlookup formula help
Hi, I am doing a VLOOKUP in which the formula looks up a list of holiday dates listed in a range from a second sheet. If matching, it is to display the second column which identifies the type of holiday (note, in the formula below I have "false" I also tried "true"). The columns sources are both type: date. the formula:…
-
Simplify Formula
I have a formula that checks to see if a date falls between dates. If so, it marks the row current or previous. The goal is to see if the date falls in the current year or the previous year and then label the row accordingly. The formula references another sheet where the dates are calculated. It has a column for the start…
-
formula for date
I have a column titled "order submit date" i would like for the formula to put a checkmark or flag (which ever is easier) in the "process time" column if its been 5 days since the "order submit date entry" do i have the formula sort of correct? =IF([Order Submit Date]@row >= TODAY(5), not sure what goes here to return a…
-
VLOOKUP example provided in documentation does not appear to be correct?
Smartsheet VLOOKUP example does not seem to be correct. In the example VLOOKUP Function | Smartsheet Learning Center, unless I'm missing something, the first formula example "IF([In Stock?]1 = 1 (true), VLOOKUP(“T-Shirt”, [Clothing Item]1:Status3, 4))" defines the table starting "Clothing" column row 1 to "Status" row 3.…
-
INVALID DATA TYPE error when using MONTH()
Hi, I'm working on a formula that will use a date to reference a value in another sheet: The sheet that will be referenced looks like this: I'm planning on using INDEX and MATCH to get a date value from a row in the first sheet to return a percentage value (based on the month that row occurs in) from this sheet. The…
-
%Complete
I am looking for a formula that will calculate % Complete based on two dates. I have been successful at getting this formula to work on projects that have already began but completed dates or not started dates are giving me a percentage that is negative or above 100. I would like projects that have not started to say "0"…
-
Automation - Sheet Update based on Criteria
Hello again Like a typical N00B I'm having wonderful ideas with almost no knowledge of the product (go easy, I'm just rolling into my 5th hour in 2 days of using it) I wanted to know if anyone has any experience or thoughts on how best to approach this scenario as I've found some challenges with my current workflow…
-
Formula to evaluate child statuses to determine the parent status
I have different milestones in a project and want the parent milestone level to show a general "temp" based on the statuses in the child tasks below it. The thought is, if any of the child tasks contain a status of "delayed, on hold, blocked, requires update" the status cell on the parent Milestone row should turn yellow.…
-
Count Criteria But Not Blanks
Hello! I am trying to count if a number is less than 45 but leave out the blanks. I have the first part of the formula working, just having trouble with the "do not count if blank" part. Can anyone help? =IF([Days to Complete Calc]@row < 45, 1) Thank you!
-
Exceeding 100% Completion
How do I override the system to account for more than 100% Completion. For instance, the initial project accounted for 4 visits; and when the project was completed the client wanted an additional event. When I add that event the Completion still adds up to 100% and not to 125% to show that the project went over scope.
