-
nesting If. Can't figure out why I get unparseable error
Here is my formula. It is in a project plan: =IF(TODAY() > [End date]1, [% Complete]1 < 100%, "At Risk", "On Time")
-
Help With Getting a IF statement to work when using columns referenced from another sheet
Hello all, I have a sheet that I'm trying to get the elapsed time in days from when a ticket was open to when it was closed. I am doing this using a second sheet, so the formula uses sheet references. I am having trouble getting this to work when using a range of items. When I use the COUNTIFS function, using areferenced…
-
Converting result from an Index & Match formula from date to text
Hello all, I am trying to work on a formula to make it easier for me to work on Global Updates in Control Center easier in the future. I currenly have a formula that coverts the data from Date to Text instead of just a simple link to the (lets say) the Start Date column; I had to do this because of the Global differences…
-
Cell formula that will highlight a task expired if any of its sub tasks are expired
Hello All, I'm trying to create a cell formula that will highlight a task expired if any of its sub tasks are expired. For example if a parent task has any child tasks with due dates earlier than the one of the parent it should be marked as expired. Is there a formula available for this? Thanks
-
VLookUp and Multiple Rows.
Hi, I'm pulling two excel sheets into SmartSheet. Sheet 1 is called the MASTERLIST Sheet 2 is Called the SALESFORM. The SALESFORM pulls data from the MASTERLIST. What I want to happen is in the SALESFORM I enter an Item Number that is in the MASTERLIST and data from that row fills in in the specific spots. Example. Item…
-
Project sheet - with multiple duration columns
Hello I need to add multiple columns that allows us to input the "on site date", - "Manufacturer Lead time" - "Drawing Approval" = Drawing start Date. Screenshot as below. Appreciate any help to solve this issue. Regards Daniel
-
VLookup with multiple requirements
I have read several community threads already, and can't seem to find what i am looking for. I have a Vlookup table that includes Pipe Type (Copper or SCH 40), Pipe Size (1, 2, 4, 6), Pipe OD (Different OD based on Pipe type) in 3 separate columns. I want to show the Pipe OD Based off the Pipe Type and then Pipe Size. I…
-
IF/OR function
Hi All, I am trying to create a formula (assuming a combo of if/or is the way to go), but keep getting "incorrect argument set. They work independently, but not when I combine them. I basically want to search for either of the following in a cell and then return a value. Look for any of the following in one column: *…
-
Count numbers separated by semi column/text in a sum formula
Hello in Column3 I have this as my first row: ="Total: " + SUM([Column3]2:[Column3]5) + " Ind & ↑: " + SUM([Column3]4:[Column3]5) * [Column3]2: 3 * [Column3]3: 1; 1 IP * [Column3]4: 4; 2 IP * [Column3]5: 0; 1 IP To keep aesthetics nice I don't want to break the cells up. Can someone help me get a formula that will add the…
-
Averages and sums in data based upon a name column
Hello, I have a Smartsheet here with some data formatted by Name, Date, Number Done, and Hours. This data is populated by forms. Here's a live Smartsheet example: https://app.smartsheet.com/b/publish?EQBCT=e6247aff028844ff9da1e4d0906860c2 Does anyone have any ideas how I can get the following: * Total Sum of [Number Done]…