-
If Imported File Contains the Same Value in a Field Multiple Times Automatically Create Children
Okay. This is super hard to explain. Here it goes, I will be importing an excel file to smartsheet through zapier. One header field is called "Reference". I will be importing orders, and how it exports into Excel, each individual product on ONE order will have the same Reference number. For example, 5 rows might say…
-
Get a list of Distinct / Unique values
Hello, Gentlemen! Here is the situation: I need to get a list of distinct/unique values in a column using a formula on Smartsheet. I know how to create this formula on excel, but when i convert to Smartsheet, it simply doesn't work. The formula that I used in Excel is the following: =IFERROR(INDEX($A$2:$A$10, MATCH(0,…
-
Auto Numbering out of sequence when sections copied
Okay, I finally got this working the way I needed. As this project grows I will need to "copy sections" down for additional data. The gray row is for a parent, and the white are the child rows. The column labeled "Auto" uses the Auto number format. But for the life of me, I do not understand WHY I cannot copy down sections…
-
Countif date is in the next 30 days
Can a COUNTIF (or other formula) count if a date is in the next 30 days or is in the past compared to the inspection date? I have conditional formatting flagging this, but would also like to count how many date violations there are as I will eventually add more expiration date columns. I have only been able to figure out…
-
Formula Help
I am trying to write a formula that shows "Delayed" if Actual Completion Date is < today or Estimated Completion Date and show "On Time" if Actual Completion Date is => today or Estimated Completion Date. My formula is getting an unparseable message but I cannot figure out why I am getting an error. =IF(OR([Actual…
-
Formula is #UNPARSEABLE
Hello community, My formula below is showing #UNPARSEABLE. Can someone please help me figure out why? Formula: =IF([Job Complete]@row "Cancelled", "", (IFERROR(IF(ISBLANK([CIT PPO #]@row), "", IF(TODAY() > [Invoicing Status Due Date]@row, "Non Compliant", "Compliant")), "")
-
Count if contains keyword?
Hi, how do I do a formula that will count keyword or keyword phrase? For example: How do I count have many times in a column the phrase "6.12 applies" was used. Thank you
-
Summarizing a column in a report is only giving me a sum of half the data
I built a report from two separate sheets using a row report. I intend to add onto this weekly. When I try to total the sum of one column it's only giving me the value of half of the data. It's only giving me the total amount from the bottom half. Is there another way to group this information? In both sheets I've named…
-
How can I sum cells that include the abbreviation of states, but include commas in between?
As of right now I am summing selected cells, which then gives me everything that is in those cells. It is then merging them together, but I need it to include a comma if there is more than 1 cell that has information in it.
-
OR in COUNTIFS Formula
Helllo Community, I am struggling to figure out this COUNTIFS formula with OR included. I am trying to count the amount of cells on a separate sheet that have the same part number and their status is either "Repaired" or "Beyond Repair". I will paste my current formula below, and it is outputting invalid operation. Any…
