Formulas and Functions
Let the community help you with that tricky formula or function! See how others are utilizing the power of formulas and functions to save them time and create more powerful solutions with Smartsheet.
Discussion List
-
New Report features on a DashboardIn Formulas and FunctionsHello everyone, happy Friday, So a colleague of mine reached out for some support on creating dashboards. Our organization recently switched from the Google sheets platform to Smartsheets, so there is a solid skill gap amongst us all. So …
-
Attachment alertsIn Formulas and FunctionsDears, Would it be possible to set up an alert when CERTAIN USERS UPLOAD DOCUMENTS? In this case we would need to be notified when our customer - only our customer uploads documents. We upload documents as well but we do not want to get n…
-
SUMIF Partial TextIn Formulas and FunctionsI'm trying to sum the contract amount if the contract status contains Awarded. Contract Status is a multi-select column so may contain more than one status. =SUMIF({Contract Status}, CONTAINS(@cell, "Awarded", {Contract Amount…
-
Multiple IF + IF(NOTIn Formulas and FunctionsHello and happy New Years to everyone, I am a little stuck on a formula and would need your help. Here is my formula: =IF([Column2]@row = "France", IF([Primary Column]@row = "Value 1", "Value A", IF([Primary …
-
Which children have status completed in the last week?In Formulas and FunctionsI have a smartsheet tracking development of a new product and I want to put in the summary sheet how many units have been completed in the past week. How do I do that using the children function? Thanks!
-
Help on IF Formula - Multiple StatementsIn Formulas and FunctionsHi! I need some help on a IF Formula statement. On my sheet, I have a column that is using this equation - =IF([Total ALL Athletes and Unified Partners]@row = 0, "0", IF([Total ALL Athletes and Unified Partners]@row <= 5, &qu…
-
Nested criteriaIn Formulas and FunctionsI have this formula but it comes back with a "nested criteria" error message: COUNTIFS([Business Unit]:[Business Unit], "MGS", Location:Location, "R6 (Orange County)", Stage:Stage, OR(@cell = "3 - Approve…
-
Why isn't MAX returning the most recent DATE?In Formulas and FunctionsHi All, I'm trying to use MAX to show the most recent date in column that's "Auto-number/System - Modified (Date)", but frustratingly it's not always correct. Anyone have any idea as to why? And more importantly, how to fix?
-
IF-WORKDAYS CalculationIn Formulas and FunctionsI have a sheet with a [Request Submitted] column. Our SLA to attend to any received request is 2 business days. So I'd like to add a column that highlights any overdue items. My logic is: If TODAY is 2 business days past [Request Submit…
-
I'm looking to add a column and formula to calculate Planned % Complete. Can anyone help?In Formulas and Functions