-
"Incorrect Argument Set" error
The following formula works: =COUNTIFS({Sales & Leads Box}, 1, {Month created}, "June", {Year}, "2022") However, I'm getting an "Incorrect Argument Set" error when I try to add in one more criteria to this formula and not sure why: =COUNTIFS({Sales & Leads Box}, 1, {Lead Category}, "Verified Lead", {Month created}, "May",…
-
Enhancement Request: Hide formulas from Viewers in Reports
A Viewer has little reason to need to see a formula in a column that is being displayed to them in a Report. Please remove the hover for the Formula (the other hover that displays the full contents (display value) of the cell is OK, just hide the formulas. Or tell me why this is a good feature.
-
Maximum number of cross-sheet references per sheet
Dear Smartsheet, Please tell me that the below error is just a soft cap like the 5,000 cell-link limit. I probably have 100 unique cross-sheet references in a metadata sheet I've been putting together. I am about 90% of the way through and just encountered the below. The way my sheet has been structured makes it impossible…
-
FORMULA(S) ERRORS
I have been trying to "MATCH/NO MATCH" values in sheet A with Sheet B. first by columns to ensure data integrity then to do a formula that will return MATCH/NO MATCH if all criteria is met, with an "@cell " formula to match =IF(COUNTIFS({PAYEE}, FIND(Payee@row, @cell) = 1, {DATE}, FIND([Invoice Date]@row, @cell) = 1, {INV…
-
Task Health
I am having hard time to have a formula to obtain the health color for the task I have 3 columns: End Date, Circuit Quote% Status and Quote Health IF(AND( [Circuit Quote % Status]@row <=0.5, [End Date]@row <= Today (7)), “Red” IF(AND([Circuit Quote % Status]@row >=0.51 , [Circuit Quote % Status]@row<=0.95, [End Date]row,…
-
TASK % COMPLETE FORMULA
I created a column to be provide me the task (row) total % complete. The two columns below have a dropdown status that each represent a % complete The % for each status is below: =IF([2nd Circuit Status]@row = “N/A”, IF(OR([1st Circuit Status]@row = “Waiting to sign the contract”, [1st Circuit Status]@row = “Waiting for…
-
CountIFs to count multiple items in same column
I want to count the instances of both "Complete" and "Not Applicable" in the same column. I got it to work with just "Complete" then divide by the total rows to make a percentage using this formula: =COUNTIF(Status:Status, "Complete") / COUNT(Status:Status) But when I add the other variable the formula does not work, I…
-
Formula using WORKDAY, TODAY, ISBLANK - #INCORRECT ARGUMENT
I want to calculate the number of days that a ticket is in Backlog. [Ticket Status]@row = "Backlog" WORKDAY([Date Submitted]@row, TODAY()) is the number of days from the date of submission to current date. I realize that my Date Submitted cell sometimes is blank so I added: NOT(ISBLANK([Date Submitted@row]) check. Now it…
-
Sumifs syntax help
trying to get a sum for the number of OT sessions for each student in a given week not sure what's wrong with my formula =SUMIFS([Todays Week ]@row, {Week Number}, [Student Code]@row, {OT Student Code}, {OT Sessions},=>1) I'm trying to sum the number in the OT session column of a separate sheet if the week number matches…
-
Evaluate if a Date column is blank
I have three columns with the below formula in the "Helper - Overdue" column. This works correctly for when there is a date in the "Deadline" column and the "Item Completed" box is not checked. It also works correctly for when the box is checked. The part that is not working is when the date column is blank, it shows as…