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
-
Update Requests - Displaying (via Reports or Dashboard)In Formulas and FunctionsDoes anyone know if there's a way to Display Pending Update Requests? We're using a lot of automation to send out Update Requests to team members, and I'm concerned that they're going to get lost in emails. It would be great if I could bui…
-
How do I extract dateonly from system generated date columns?In Formulas and FunctionsHello, I would like to create conditional formatting based on a system-generated date being more than 7 days in the past (my test is if it's less than 6, then trigger the flag). I created a helper column to do the math, upon which the cond…
-
Replace data in cells of moved row for formula of cells above in destination sheetIn Formulas and FunctionsI've created an automation for moving a row to another sheet. After moving I want in some cells that the original data that came from the source sheet will be replaced for a formula as in the above rows of the destination sheet. Until now …
-
Formula to add incoming inventory to existing inventory?In Formulas and FunctionsHello, I am trying to figure out a formula for my inventory sheet. I am trying to create an automatic formula that when a shipment is marked received, it will update the inventory sheet. I thought it would look like =SUMIFS({Customer Orde…
-
Calculations with datesIn Formulas and FunctionsI need help figuring out date calculations. I've tried many different things and nothing works so far. I have a list of projects, each project has a list of tasks with start and due dates. I need to calculate the difference between the st…
-
Ignore blank CellsIn Formulas and FunctionsHi I'm trying to get the following formula to ignore blank cells =INDEX(([1]:[1]), MATCH(MAX(Created:Created), Created:Created, 0)) Can't quite get it to work.
-
nested if formattingIn Formulas and FunctionsHi, Could you please share a proper format of a nested if statement? getting UNPARSEABLE error: =IF([% Complete]@row <= 0.7, "Red", IF([% Complete]@row > 0.7, AND,[% Complete]@row < 1,"Yellow"),IF[% Complete]@…
-
RYG health and status indicator roll-upIn Formulas and Functions(Image) I currently have something similar like this setup for a number of projects, for each of the deliverables, I use the following formula: =IF(Status4 = "Complete", "Blue", IF(Status4 = "At Risk", "…
-
Struggling with SUMIFSIn Formulas and FunctionsDear Community, I am desperately trying to make a SUMIFS function work. I have to columns with dates, Start date (startdato) and end date (slutdato). I need to count the days in the period between start date and end date, and add them, whe…
-
Scanning QR codesIn Formulas and FunctionsHello everybody! Ive got a QR code that has 3 lines of text, and when scanning it, they are merged into one string w/o spaces. Is there somehow I can scan the code, so that the 3 lines are put into 3 different columns instead of them being…
