-
help with If function
I have the following if function (IF([Audit Start Date]3, ([Audit End Date]3 + 7), "Audit to be Scheduled") and I get Invalid data type. the formula works when there is no date in column. However, formula does not work when there is a date in column. I dont know what else to try. This formula works in excel...
-
Struggling with SUMIFS
I am trying to use SUMIFS to total a column from another sheet ({Recap Total Range 3}) with the following 3 criteria - matches unit #, and between two dates, I continue to get either impearsable or incorrect argument and hoping for some help. =SUMIFS({Recap Total Range 3}, {Recap Total Range 2}, >=$[Start Date]$1, {Recap…
-
How do I extract the values from a multi-select dropdown?
I am trying to count values from multi-select dropdown. We asked how many check-ins people would like to have: 1/year, 2x/year, 4x/year, etc. (a total of 6 options). When I did my counts, rows with more than one selection weren't counted. For instance, someone chose 2x/year and 4x/year. However, when I use the formula…
-
Formula Help
Can anyone help with this formula? It works in excel but I am getting Unparseable error in smartsheets. =IFERROR(IF([QTY]@row,<>0,[QTY]@row*[Production Rate]@row),IF([Linear Feet]@row<>0,[Linear Feet]@row/[Production Rate]@row,[Sqft]@row/[Production Rate]@row)),0) Thanks for any help
-
At Risk Flag
Hi there! I am trying to have it so that the flag shows if the End Date is 3 days away AND the Status is "Not Started" (ideally, I would like it to show if the status is anything but Completed, but that may be too difficult). I know to use a nested IF/AND function, but I keep getting errors when I write it out. I started…
-
How do I get an unduplicated count of names from a cell range, filtered by date?
I am creating a sheet summary for a sheet that includes a column called "School Name" and another column called "Program Inclusion Date." Some of the schools are listed more than once in the "School Name" column, and I am trying to get an unduplicated count of school names with dates in the "Program Inclusion Date" column…
-
Request Time Off Tracker Help
Hello, My story seems to be familiar to others, but no past post seems to have a good solution. I've been searching the community forums here for a request time off tracker template (found a couple none actually worked), ended up creating my own. I got the majority of the automation and formulas worked out but I'm stuck on…
-
Nested IF Statements and RYGB balls
I have a status column that is being manually entered based on the days past due. I am trying to automate RYGB balls. I have gotten the equation to record what I want for Red and Green, however, I would like to have a blue one appear if the if the status is in queue. The problem I am running into is that the Days Past Due…
-
IFERROR Formula for Dividing By 0
Happy Friday All: I am trying to replace IF Formula with IFERROR so I do not receive #DIVIDE BY ZERRO Error. However, I receive Incorrect when I use the IFERROR. Can anyone help? Existing Formula: =IF(AND(TODAY() >= [Start Date (Planned)]18, TODAY() <= [Finish Date (Planned)]18), ROUND(NETWORKDAYS([Start Date (Planned)]18,…
-
Ghost data from unused SCC template remains
I have three different gantts with some summary data that is fed into the main project data sheet. Only one of the gantt sheets is used in a project, so I thought of linking each of the gantts' data (exact same field/cell in each sheet) to a cell in the project data sheet - then just grab the one that isn't blank or an…
