-
How to update INDEX formula criteria in a specific way?
My company has created a freelancer invoicing system using two sheets. It depends on an INDEX formula that we now need to improve, which I'm having trouble doing. Sheet #1: A database with information on all individual freelancer (aka subcontractors) contracts (aka SOWs) Sheet #2: A form-based tracker with notifications…
-
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…
-
Month Function Sorting in Report
Hello! I have a sheet that captures items and their start/end dates in a date format. I am trying to create a report that will group the items by the Month that the item is taking place in chronological order (Ex: All items with the target end date in January would be grouped under "January", followed by all items with the…
-
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…