-
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…
-
Need empty column blank
I want to use a formula like this below but if there is no date in the other column to add +14 to, then leave row blank. =([CONFIRM OW PHOTO DUE]@row + 14) Need the "14" left blank
-
WEEKNUMBER and WEEKDAY
I've built a Smartsheet (with some help from the ProDesk) that assigns a task to a contact based on the date/time of a request. The sheet looks at the date stamp on the request then references another sheet (using WEEKNUMBER and WEEKDAY) to see who's "on duty" at that time. That contact's name is pulled into an "Assigned"…
-
extract part of a cell's text
Hello, New smartsheet user here. I have cells that contain dimensions of objects. A cylinder, for example, looks like this: Ø120*12. I need a way to extract just the text to the right of the *, in this case 12, to another cell. Another example: Ø18*1000 would return 1000. How do you do this? Thanks!
