-
Getting Incorrect Argument Set on Formula
Hello! I am trying to configure a formula to sum a spending detail sheet where it checks for the COA line and a Reconciled checkbox to be checked. I have a similar formula that works without issue that checks for another checkbox field to be checked. I copied the working formula to this new area for the formula and it is…
-
Difference between the first entry and last entry
I want to find the difference between the first entry and the last entry for the numbers in the "Current" column. I am using this formula: =INDEX([Current]:[Current]), MATCH(MAX([Date]:[Date]), [Date]:[Date], 0)) - INDEX([Current]:[Current]), MATCH(MIN([Date]:[Date]), [Date]:[Date], 0))
-
Functions / formulas
Hi there, I'm trying to amend an existing formula in a column in smartsheet. The formula contains a few different variations. So it's basically, IF "Order Type" is "Renewal", use xx.cc@…, IF Order type is License use CDXX@XXX etc. So it's using specific email contacts when it's a different Order type. What I want to do is…
-
I want to send automated email to "assigned to", from a sheet, but only one reminder email vs mutlip
I have title, "assigned to" column, status(task 1), due date (task 1) columns, status(task 2), due date(task 2)…it goes for at least 10 tasks. The conditions to trigger the emails are, trigger 2 days before due date(when status is not equal to completed) and leave weekends trigger on due date(when status is not equal to…
-
Can't use the new "Timeline View" when leveraging the new "Columns Link" in Table View
What I'm trying to do: I'm trying to leverage some of the new/upcoming features from Smartsheet to put together a sheet that brings information from multiple sheets to generate a timeline view of our Program Portfolio. The problem I'm facing: Column Linking in Table View uses essentially column formulas. Timeline view and…
-
If Formula
I need help understanding why I keep getting #INVALID OPERATION with this formula. It only happens when I want to look at Audit Status. I know its a large formula but Im using it to check for missing items and notify the team on next steps. =IF( OR(ISBLANK([Profit Center]@row ), [Profit Center]@row = "⚠️ PROFIT CENTER NOT…
-
Conditional formatting for "where % complete is not equal to 1" is not working
I have a project plan where I'm trying to set conditional formatting where % Complete is not equal to 1 and Finish Date is in the past, to turn row Yellow. It is not working. Please advise.
-
Can anyone spot what is wring with this formula?
=IFERROR(IF(ISBLANK([C1D1 Date]@row ) = 0, IF(ISBLANK(INDEX(COLLECT({Patient ID}, {Visit Collection Date}, [C1D1 Date]@row , {Sample Name}, "PK PRE PRI", 1)) = 0, "Received")), "Not Received"))
-
Issues with the Subject line of automated messages from the Smartsheet
Hi, I recently automated using manage workflow where Smartsheet will automatically send out emails to specific group of people about a product delivery when a date criteria is met. The message looks like this Subject: Parts shipping on {{Delivery Date}} Message: Hi Below parts will be shipped out {{Delivery Date}} linking…
-
Can you collate Ancestors based on another column condition?
Hi all, looking for some formula help. I would like to collate the names of my ancestors for a task in my "Stage" column, but only if the Hierarchy level of that parent or grandparent is >= 3. I have tried utilizing the Join(Ancestors(Task@row), " - ") and this returns all of the parent tasks. When I try to utilize an if…