-
IFTEXT vs something for numbers not just text
Hello Community, I am using an IFTEXT function to automatically check a box in one column if the cell in another column(s) has text in it. I also need it to check the box when the other corresponding cells have, not only text, but numbers as well. Is it possible to combine the functions to allow for an "OR" command that…
-
Creating a formula that uses the output of a formula in another column
I have column that generates a True /False answer using the formula below: =IF(ISBLANK([Published date]@row), "", (IF([Published date]@row <= [Date due]@row, "True", "False"))) I want to work out the percentage that are "True" in a separate column. The formula I had created stopped working a while ago and shows as #INVALID…
-
Trying to Count how many times a specific date populates
I am trying to count how many times each of of the dates in 'Clean Up Date' populate so I can set up a notification to deactivate the form that feeds into this sheet after 8 people sign up for each date. I've tried typing in CountIF formulas referencing similar questions asked in the past but nothing is working. I even…
-
How to Incorporate Durations in COUNTIF formulas with Calendar App
Hey all, I am having issues rolling up calendar availability with the durations. If you look at the calendar attachment picture, I want to have 3 jobs scheduled for 7/17/21 but we have a job with a duration of 2 days the day prior which makes it more like 4 jobs scheduled. I have a cross-sheet reference off the main…
-
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?