-
NEW! Your survival guide to formulas is here. Meet the Formula Handbook.
Hi Community, Whether you’re summing child rows, calculating budget minus actual, or doing cross-sheet data lookups with multiple criteria, formulas are a must for tailoring solutions to your needs. The new Formula Handbook is here to help formula beginners and pros alike. This template contains: A glossary of all…
-
Countifs for if either column is checked
I have two checkbox columns and need to get a count of how many rows have either or both of the check boxes checked. I am struggling on how the formula to accomplish this is the sheet summary. Below is my current equation for getting the count of one of the columns, I am able to do this for both to get a count for each…
-
Formular Stripped from cell when the row moved into different sheet
Hello, I use simple formular to assign Due date =WORKDAY (Start Date, #of days) to add. I love it- Simply Works! Attached image. Now, when this row met workflow automation criteria, and then move into different sheet as completed, the formular no longer display. Only show Due date value. It this stripping formula normal? I…
-
My IF statement isn't importing from excel and can't figure out why
I have what I think is a fairly simple nested if statement that isn't importing into Smartsheet, it just shows blank and I can't figure out the issue. The excel formula is: =IF(ISNUMBER(C2), IF(AND(ISBLANK(X2), ISBLANK(Y2)), TODAY() - C2 + 1, IF(AND(ISNUMBER(X2), ISBLANK(Y2)), X2 - C2 + 1, IF(AND(ISNUMBER(X2),…
-
Form not auto populating fields if one column cell contains a comma
I'm using a form that when triggered, populates several fields from a source sheet then posts to a another sheet. I've noticed that if the column titled "Description" has a comma in the text of a cell, such as image 1 below, then the form will not auto populate all of the fields that I want. It will also stop populating…
-
Countifs off by one
I am trying to get a count for a date range, but am getting a number that is one less compared to the filter. Current Tuesday Formula: =IFERROR(TODAY() + (3 - WEEKDAY(TODAY())) - IF(OR(WEEKDAY(TODAY()) = 1, WEEKDAY(TODAY()) = 2), 7, 0), "") Previous Tuesday Formula: =IFERROR(TODAY() - 7 + (3 - WEEKDAY(TODAY() - 7)) -…
-
Issues with Convert to Column Formula
Hi, I have a column that I'm trying to convert to column formula but won't because "The column formula syntax isn't quite right" and gives me Smartsheet's help article for more information. The column's type that I'm trying convert is "Symbols" and is the Progress Bar. The Formula of the attached example is: =IF([RPM %]851…
-
Charting a multi-select column using a metrics helper sheet.
I have a sheet with a multi-select column (Law Firms) and I wish to show a chart in my dashboard that displays a count of the unique firms in that column. I created a separate metrics sheet with one column (Law Firm Names) containing each unique value contained in the multi-select column. In my other column, I'm using a…
-
Creating Report
I want to compare QtyShipped in sheet 3.2.6.2 to the Qty in 3.2.6.1. The QtyShipped in sheet 3.2.6.2 lists the quantities as we ship the parts and Qty in 3.2.6.1 is our contract requirement quantities. Is there a way to sum up the quantities in the QtyShipped in sheet 3.2.6.2 and see that next to the Qty in 3.2.6.1. We…
-
Formula Help - if cell = X then show network days
I hope my explanation makes sense. I currently have a basic formula that shows "networkdays" between 2 dates, however it obviously shows "invalid date type" when the "end date" has not been entered =NETWORKDAYS([Date Open]@row, [Actual Closure Date]@row) . So we want the cell to show "duration to close" when status is…
-
Need help with an odd notification
Good morning, I would like to set up a notification that sends when an invoice has not been submitted (No invoice received date) within 3 days of the due date. The issues I have run into are because there are multiple contracts, they have different due dates, and I want this to trigger monthly. So if contract 1, that has a…
