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,…
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 …
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…
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 …
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…
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 "…
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 brok…
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 u…
Hi I'm using 5 days a week in my project sheets and I want to convert the variance column into weeks baseline in weeks in working out the duration between the baselines dates (please ignore) please ca…
I thought I had this all figured out a while back, until diving back in now I notice that a handful of my dates are not working correctly. I figured out it is all of the rows where the person has a bi…