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
-
Date Automation is not workingIn Formulas and FunctionsI've got an automation set up in a way that if a row is added, the date gets captured. However, when adding data to a new row, this does not seem to work. I've even waited for 30 + mins since some discussions have mentioned a 'delay' in th…
-
Using several conditionsIn Formulas and FunctionsI am trying to build several conditions into my Smartsheet, is there a limit as to how many we can have? This is the conditions I need to have set: GRAY - when renewal status column status are selected: Awaiting Information, Bound (Lead)…
-
Formula Dates vs Gantt displayIn Formulas and FunctionsHi all, I have an issue using function + dates + showing them in a Gantt chart. The scenario is the following: I have three columns set as type Date: Contractual date, Starting date (of execution) and End date (of execution) The Contract…
-
Formula returning #nomatch when flash filled (original formula does not have error)In Formulas and FunctionsHello - I wrote an IF(Index(Match formula to reference a checkbox between 2 sheets (if checked in reference sheet, check in target sheet). The original formula works, but when I attempt to fill the formula down my column, it starts throwin…
-
Referencing a column from the top down to the current row - WITHOUT ABSOLUTE REFRENCEIn Formulas and FunctionsI am trying to refer to a column from the #1 row down to the current row in a formula For example say I have a column called Monthly Cost, I could have a formula =SUM( [Monthly Cost]$1:[Monthly Cost]@row) And that formula will very nicely…
-
Assigning People using IF Formula or the new Assign People Workflow?In Formulas and FunctionsI am setting up a request register where the client logs a request via a form. I want to then notify specific key people depending on what account the request is for to review the request and work on next steps. The people sit in 3 key gro…
-
Limited characters for a condition within a workflow?In Formulas and FunctionsHi, I am working on setting up a workflow in my Smartsheet. One of the conditions I want to setup is from an existing drop down menu I created in the Smartsheet. Within this drop down, there is an item with a longer title that does not sh…
-
URL Query Strings & ContactsIn Formulas and FunctionsHi I am using a query string with a form URL to prepopulate a form with row information, which is passed to another sheet. All works but I am have challenges with passing contact info. The source form has a column property of "Contact…
-
Smartsheet marking items late -In Formulas and FunctionsHi (Paul, if you are listening!) I have a formula that determines if an application is on time or late - It is marking applications that come in on the same day as the Final Filing Date as LATE (i.e., received date = 4/20/21 10 am, FFD 4…
-
Cannot calculate future date based on two source fields.In Formulas and FunctionsWhen adding a set of days to a historical date usually that will give you a future date example: =[Sale date]@row + [Delivery days]@row will give me a future date When using Data mesh or Vlookup to bring the two source fields to another r…
