-
Using a formula to modify the contents of a multi-Contact cell
Hello, Here's the idea: Use a formula that when given a contact cell with multiple assigned contacts, and a secondary cell with one assigned contact, it will SUBTRACT (or otherwise modify) that contact from the first cell. So in practice it would look like this: Cell 1: Contact1, Contact2, Contact3 Cell 2: Contact2 Cell 3:…
-
Count how many times a row is changed to get a percentage
Hello, My goal is to return a percentage of how many times we hit our deliver date the first time. I want to see how many times the deliver date is changed to get a percentage of how many times we hit the first deliver date we put in the field. So to do this I am having the sheet copy the row into a helper sheet and then I…
-
"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…