-
Start and End Dates
As you can see from the picture below I have set up my columns to track certain dates. I work in construction so I have typed in what the GC gave me as a schedule. That is the Start and Finish and there duration. What i am trying to figure out is. When Status changes to "In Progress" I would like for it to Record the…
-
New to Smartsheet. trying to figure out a formula
I am trying to figure out a formula that will help me track data. I work in construction so I think this will help me out. Example, I have 100 duration days to complete interior framing. I have gone through the schedule a picked what is interior framing and that will give me a % complete of what is done. Now what I am…
-
#Invalid Operation - Referencing another sheet
I am having trouble with this error. Pulling data from a sheet with same column names. (dumbing my equation down for simplicity) {Master Daily Job Log Range 1} = Date Column in Master sheet. {Master Daily Job Log Range 2} = Job Overview Column in Master sheet. Equation in my Yesterday's Job Report Sheet =IF({Master Daily…
-
Adding a text in formula
Hi Smarties, I have columns of checkboxes across the sheet. I would like to make a formula of "Total Number of checked boxes are: ____" The below formula seems to work well counting all checked boxes across the sheet. =COUNTIFS([Value 1]4:[Value 4]106, =1) + COUNTIFS(Completed4:Completed106, =1) + COUNTIFS([Critical…
-
Sum Formula with other data is cells
Hello - Hopefully this is a simple question. I have a column that I am trying to sum the data in but the cells quantities and data inside each cell. Is it possible to sum the total quantity for the column? I am trying to avoid using a helper column to move the number out and sum off that if possible. The quantity's can…
-
Filtering for critical path to a milestone
Hi everyone, I have a project that spans multiple years and contains many workflows. I would like to be able to track the critical path to different milestones (not just the last task in the sheet). Are there any tricks to doing this in smartsheet?
-
Vlookup Contact List... Recognition after Save
I'm using a helper column with Vlookup to populate a email address from a contact list sheet based on the name of the person in an adjacent column. The contact is populated properly when the sheet first opens but then it's like it is not recognized after a couple seconds of being open and thus is not brought into a filter…
-
I have been trying to think of a way to get around Smartsheet's lack of a =FILTER function?
I have been trying to think of a possible work around for an =FILTER type function, I have been using Smartsheet for a few months now and the last thing I need before I can fully move over to Smartsheet from google sheet and excel is a auto-generated summary sheet based off a a row in another sheet. I will attach some…
-
How to return more than one value with multiple serach values with vlookup
Hi, I have two columns ID and C. Based on a vlooup formula in C with the search value in ID and need to show the value in C. My Question here is when I need to show multiple values based on multiple IDs. Example: If ID1=Result1 ID2=Result2 and ID3=Result3 and in ID column I write 1 2 or something like this and i want to…
-
Calculations based on form field entries for data validation
I'm creating a form in which staff enter #s into each of several fields. They need to total to 100 (percent). Is there any way to at least show the total live in the form or, preferably, enforce that they add to 100?