Good afternoon Smartsheet Community: I am trying to add the total from the count of 2 sheets given the criteria. However, I am receiving an INCORRECT ARGUMENT SET when using SUM or Count conditions (f…
I have this formula copied down a column: =vlookup(A1,ReferenceAnotherSheet,3). The first row bring back the correct number value. The other rows are bringing back a #nomatch. Also, I want the cell to…
I'm trying to write an IF/AND statement that references a range of data in another Smartsheet but an #INVALID OPERATION message is returned. * IF the user is requesting to use the Immersive Learning C…
To count the number of unchecked boxes I'm using the formula: =COUNTIF([% Complete]3:[% Complete]60, 0). The issue is that it is also counting blank rows. How do I get it to only count actual blank ch…
I am attempting to create a project status column that is using the Harvey Balls (red, yellow, green and gray). I am wanting these to automatically change yellow when my due date column is 120 days wi…
Hello ~ I'm calculating attendance and want to highlight inactive participants. Currently, I copy and paste =COUNTIF([20 1/6/18]3:[25 02/10/18]3, "P") each week as a new column is added. Is there a fo…
Hi, (Sorry if this has already been asked and resolved, I couldn't find anything). I currently use smartsheet for our team's training log. In doing so, there are several columns that require numerical…
Getting an Invalid Data Type error with this formula: =COUNTIF(AND(FacilityCount:FacilityCount, "TZ"),NOT(COUNTIF(Status:Status, "Green"))) The second "CountIf" is a symbols column. Looking to make a …
I'm trying to count the number of late tasks in a project plan. The formula I'm using works as long as a row isn't blank. =IF(AND(TODAY() > Finish15, [% Complete]15 < 1), 1, ""). If I drag the formula…
I'm trying to determine a COUNTIF formula to show what deliverables are due in the next 7 day period based upon a Due Date column. However, I'd like said formula to only showcase what deliverables are…
