-
Sumif formula with multiple criteria
I’m trying to write a formula for a dashboard rollup sheet and am having some difficulty. This is what I have written but it comes back incorrect argument. =SUMIF({2021 FLS Small Project Tracker Range 1}, "Reserve Fund", {2021 FLS Small Project Tracker Range 3}, "Apparel", {2021 FLS Small Project Tracker Range 7}) I want…
-
Advanced Filtering by MAX value
Hi all I've created a report and wanted to know if there is a way to show unique rows by the highest date value For example - below I would like to see the bottom table as my report (colours are just to show the matching rows - they are not part of the conditions required) where only the unique rows are pulled through…
-
COUNTIF Formula Only Works on Certain Rows
Hey Smartsheet Community, I am currently being stumped by this formula that for some reason only works in a few rows. It is a COUNTIF formula that is counting the number of assignments each person has. I will paste it below: =COUNTIFS({Resource Name}, FIND([Qarbon Owner]@row, @cell) > 0) I have 29 people that I need to…
-
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…