-
Changing a cell value based on multiple criteria
Hi everyone. I have been attempting this formula all day with no luck. Hopefully someone here can help out. I have a sheet with the following columns: Approved, Approval Need, Sr. Dir Comm Sol Sales Ops Approval, MA Dir. Comm Sol Sales Ops Approval, Reg Sr. Dir Comm Sol Sales Ops Approval, VP Approval The Approved Column…
-
Formula to set the Task Health.
Hi Good Morning, I have a question on this formula. Can you tell me what I did wrong please? Thanks for your great help.
-
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…