-
How am I able to exclude weekends in a formula to return a number and not a date?
Hello, I need to write a formula that calculates how many days it takes to complete a PO from the time it is received., but I want it to exclude weekends. I have seen the WORKDAY function, but I am not trying to return a date. I am trying to return a number. My current formula is a simple subtraction formula. Any help…
-
Using Multiple IFBLANK Checks With IF
Hi, all; I'm trying to use an IF statement to compare multiple dates to a deadline date. This is pretty simple. If any one of the dates in question comes before or on the deadline, the condition is Green. If any of them are past the deadline, the condition is Red. The complication comes in when those cells turn up blank,…
-
Nested If Statement Not Working
I am trying to write a nested IF statement to automate the RYG status balls in a status column. It will not work, it always say they are red. What am I doing wrong? Logic Needed: If less than 70% complete, "Red" status ball If 70% or above and less than 100% complete, "Yellow" status ball If 100% complete, "Green" status…
-
Mean Time Between Two Dates from Form Submission
Hi Community, I'm attempting to find the average downtime of an asset between dates from a form submission for the month. For example below, I need to find the number of days between the "OOS Tag Removal Date" and "Date OOS Tag Applied", based only on all entries for "Asset ID" FD-001201 where the "Reason for OOS" is…
-
#no Match Error using VLOOKUP
Hello - What I'm trying to do is return the name of the team member that owns the workstream onto a different sheet. I went with the vlookup formula and keep getting a no match error. Details and screenshots below. I want the formula to look for BCG on screenshot 1 and look for it on a different sheet. If it finds it,…
-
Count IF one of many values appears
Hi there, I always get hung up on the HAS formula. I am trying to pull data for a dashboard in a separate dashboard data sheet so I am referencing another sheet, let's call it "Supplier Data" and I want to count the number of times the Category column says "3 - Duplicate" and the BU column (multi-select) has a specific…
-
Formula inquiry: Counting a specific name in multiple columns in one sheet
I am trying to create a formula within Sheet Summary to count the number of times each initiative was listed within a cell in four different columns. The columns are below. I used the following formula: =COUNTIF([Initiative]:[Initiative], [Initiative 2]:[Initiative 2], [Initiative 3]:[Initiative 3], [Initiative…
-
Adding + 1 Working Day
Good Day Smartsheet Community: I am trying to Add 1 Day to this Formula but I want the 1 Day to be a Working Day, not Saturday or Sunday. Current Formula: =[Finish Date (Actual)]@row + 1 Thanks for the Help in Advance.
-
Help: Formula Creation Request Please
Can someone help me by typing out what I hope is a simple formula? End result, when I update my "Status" column, I want it to enter the following amounts in my "% complete" column. FYI, Status is a drop down single choice column type. I will be so appreciative! I just don't time to figure it out by trial & error. Example…
-
#Invalid Operation error with simple Index formula.
I am getting an #Invalid Operation error with a really simple index formula. =INDEX(Contract:Contract, 2) This formula is in a Sheet Summary field. The summary field is text/number and the column referenced is a text/number column with a column formula that produces numbers. The column has the Currency formatting on, but I…
