-
WBS in smartsheet.
Hi. Is there a way that I can have a dewey decimal system kind of the numbering for the items on my worksheet. I have found a solution that lets me have items numbered in the format 1.1 and 1.1.2 and 1.1.2.4 etc. But I want a system where I can have the format 01.00.00.00 and 12.04.09.11 etc; How do I make sure that there…
-
Using AVGw function
Hi Everyone, In my Smartsheet project plan I originally set up a Planned % column using the following formula to calculate progress based on planned dates: =IF( OR(ISBLANK([Planned Start]@row ), ISBLANK([Planned Finish]@row )), "", IF(PARENT(Primary@row ) = "External Dependencies", "", IF( TODAY() > [Planned Finish]@row ,…
-
Nested SUMIFS / OR / WEEKNUMBER functions
Hi, how can I combine these two functions? They are both working separately for me for the same range of data. =SUMIFS({MGHours}, {MGNum}, OR(@cell = [Project Num 1]@row , @cell = [Project Num 2]@row , @cell = [Project Num 3]@row , @cell = [Project Num 4]@row )) =SUMIFS({MGHours}, {MGDate}, WEEKNUMBER(@cell ) =…
-
Primary column data to other Sheet
I have 2 sheets, Sheet A has Primary column and I want to copy Sheet A primary column to sheet B. Sheet A has 2000 lines in primary column also whenever I update Sheet A primary column I need it should be updated in Sheet B too. how I can do this in Smartsheet?
-
INDEX COLLECT give #INVALID VALUE error but INDEX MATCH does not
INDEX COLLECT gives me an #INVALID VALUE error =INDEX(COLLECT({event-25}, {date-25}, Day@row , {ID-25}, [Employee ID]@row ), 1) ========= But using the same reference for INDEX MATCH does not =INDEX({event-25}, MATCH(Day@row , {date-25}, 0)) or this =INDEX({event-25}, MATCH([Employee ID]@row , {id-25}, 0)) ========= I need…
-
Search Adjacent Row
I want a formula in a cell that searches the adjacent cell with its drop downs and then it would populate with my other referenced quantity cells elsewhere. Cell is UNIT that I select from a drop down list: S.F. Bldg., Weeks, Months, Other I want this formula in my cell at adjacent row of REF. QTY. to read cell UNIT and go…
-
Checkbox with multiple unique identifier rows
I have a checkbox column that I want to set up a formula for. This formula will reference another sheet for a checkbox, using a unique identifier. If the box is checked in any of the unique identifier rows in the reference sheet, it will return a checked box in the formula sheet. The formula I found is:…
-
Linking two sheets in a very specific way
Hello all! Like my title says, I am trying to link two smartsheets in a very specific way. I have a process in which I have individuals requesting support for specific courses this is tracked in one sheet. I then have a second process that hires people to provide support for those classes. Where I am running into trouble…
-
sumifs pulling from separate page for last 45 days with additional criteria
I'm trying to pull a total quantity of bad parts that have been made in the last 45 days. I'm looking to break this down by specific part numbers. The formula that I'm currently using is : =SUMIFS({Machine Shop Scrap Data Range 1}, {Machine Shop Scrap Data Range 2}, AND(@cell >= TODAY(-45), @cell <= TODAY()), {Machine Shop…
-
No "reference another sheet" prompt
Hi All, I'm a noob, trying to do a basic vlookup (or match, don't care), but when I start the formula, there is no "Reference another sheet" prompt, as I see in every single help video. I've tried directly typing in the name of the sheet/table, but it's not producing. =VLOOKUP([Contract Name]@row ,{List of…