Formulas
Discussion List
-
Alert when Checkbox Column gets UncheckedIn Using SmartsheetI have a formula column that gets checked or unchecked depending on some other things in the sheet. An alert goes out when this gets unchecked (and when rows get changed, not added) on an hourly basis. We recently got an alert saying that …
-
Formulas in Reports/Reference reports for DashboardIn Formulas and FunctionsI read in the community (the posts were a few years ago) that you cannot enter formulas into reports or that you cannot reference reports for a dashboard. Is this still the case? I having living data that really needs to be manipulated to …
-
COUNTIFS function with multiple criteriaIn Formulas and FunctionsHello! I've been having trouble with getting this formula correct. Here are the details. I want to count row A when "service expansion" is present only if row B has "qualifying" or "proposal" or "N…
-
Count a row if the date AND Member Number both do not match another rowIn Formulas and FunctionsI am trying to create a formula where it creates a 1 in a column where the date AND the Member Number both in one row do not match the date AND the Member Number in another row. For example, in this row, the date is 05/20/21 and the Member…
-
If/Then Statement to Return a specific dateIn Formulas and FunctionsHello, I am new to Smartsheet and though I feel like this should be a simple formula, I am stumped. I am hoping to create an automation that would calculate a due date from a date received based on the value selected from a drop down list…
-
IF Statement for automatic checkboxIn Formulas and FunctionsHello. I have two columns "Gate Status" and "Gate Current (Mdays)". I'm trying to write a formula that does automatically adds a checkbox to "CurrentGateLate" column when the following happens. When "G…
-
Metrics Sheet Pulling from ReportsIn Formulas and FunctionsHello All, I'd love to know if its possible (or a workaround) for creating a metric sheet to use in a dashboard using data from reports. We have 90+ Sheets that we can easily pull data into a report but its hard to get that into a meaningf…Answered - Pending Review 17 views 1 comment 0 points Most recent by Paul Newcome Formulas and Functions
-
Date Ranges with Multiple Conditions?In Formulas and FunctionsHello, I am trying to calculate time windows by referring to previously entered dates, but am unsure how to build a formula that takes into account multiple conditions. For the highlighted cell, there are 2 conditions that I am trying to …
-
Referencing Multiple Columns in another sheet to Match a Location and Date Range to a ProjectIn Formulas and FunctionsSo I have been looking through the community for a while and have seen a couple solutions mildly similar to what I am looking to do, but can't quite get it right. Feel free to link me to another solution if you feel it would solve this pro…
-
Lost with vlookup or matching?In Formulas and FunctionsI am needing to update a Smartsheet to reflect the date listed in a cell from another Smartsheet. Both sheets have an IP address that can be match on as there are no duplicates. The feeder sheet with the date has 210 entries and master she…
