-
OR function referencing other sheets with Index - returning INVALID COLUMN VALUE
This is driving me nuts. Sheet1: {Sheet1_CC} = Course Code (Text/Number Column) {Sheet2_MRC} = Modify Replace Code (Text/Number Column) {Sheet1_AT} = A Task Dropdown list with restricted options (NEW, MODIFY, REMOVE) Basically a course code can be in either column and I need to pull relating task into Sheet2 Sheet2:…
-
How can I change this formula to exclude holidays?
I have set up a project status report to automate expected deadline dates for certain project deadlines. My current formula excludes the weekends, but not holidays. What can I change/add to this formula to do so? =IFERROR(WORKDAY([CD Kickoff (E)]@row, +1), "") Also, if I need to have the dates counted by 4 weeks vs days…
-
Autopopulating a job number
I have set up a sheet that will house our jobs. It has been requested that each job have its own row, nestled under the customer's name. Our job numbers are derived by using the customer number, year, and job number for the year. For instance, the first job of 2024 for Customer A with a customer number of 1000 would have a…
-
Sum a column associate with children
I have the following layout, and I am trying to sum the "Ordered QTY" column for all children within each parent in a helper column so I can verify that amount with the parent "Ordered QTY". Any help would be appreciated and thank you very much…
-
Append cell value with previous value and new value from another cell
How do we append cell value with existing data.? for example. column source and target. target = target + source. so every value entered in source it should be appended to target with already existing value in target. any idea or formula , please help. thanks
-
How to use predecessors to auto update Part Numbers?
For my use case, I have a version of a product that only updates when it changes on the next version. So for example say I have an assembly that has 3 parts in it. Lets say V1 and V2 of this assembly are identical except 1 item is different so has a different number: V1: 001 [Input] 002 [Input] 003 [Input] V2: 001…
-
How can I ignore a blank cell in an IF formula?
I'm calculating the workdays between two days and updating the status in a different column. How do I make the formula ignore blank cells in the Install Difference column? =IF([Install Difference]@row >= 21, "Late Over 4 Weeks", IF([Install Difference]@row >= 11, "Late Over 2 Weeks", IF([Install Difference]@row >= 2,…
-
Weird Formula Help
I have the following columns in my sheet: Is This An Object? (a drop down "Yes" or "No" column) Object # Box # Folder # HW ID I need a formula for the HW ID column that mirrors the "Object #" IF the "Is This An Object?" cell is "Yes". However, IF the "Is This An Object?" cell is "No", then I want the HW ID column to…
-
Vlookup - #unparseable result
I built a tracker that is populated with an intake form. One of the criteria is a broker code, that when entered on the tracker from the form, is vlookup’d from a reference sheet and gives me the broker’s name, their branch code and branch name. This works perfectly fine for our purpose. Our team has now been tasked with…
-
Please could someone kindly help me with this INDEX/MATCH/IF /AND Formula
Hello There Smartsheet Community Please could you kindly point me in the right direction with my formula? Sheet 1 Contains the following sheet references "Status" = Jira Status "MMP" = MMP I need to update the value of "Validation NL" based upon the following criteria: If "MMP" in sheet 1 matches "Req ID" in sheet 2 and…
