Formulas and Functions

Archives for December 2019

SUMIF Halp!
So I have this issue I would love to solve. I have a Contract Database (Sheet #1) that holds a current contract value for that contract number (216116). My issue is pulling the child row value (Total Contract Value) to another sheet (Sheet #2) using the Job No as criteria. So i'm not sure if SUMIF or SUMIFS will do it…
Reference a cell on another sheet based of a value in the current sheet
Hi Smartsheet hive mind. Hopefully someone may be able to answer this question. I have a sheet (Sheet A) that will be tracking tickets and will have the dates the ticket was created on it. I have another sheet (Sheet B) that has every date of the year on it but another column that tells what the fiscal month is (in this…
Help with formula for multiple criteria
=COUNTIF([Academic Yr]:[Academic Yr], OR(@cell = "Fall 2019", @cell = "Prior to Fall 2019"), Status:Status, "Active")
delay in each Task
In the created project management fields, there is a start and end dates for the task assigned to the person I would like to inquire about the following cases: When I delay the task completion date, for example 3 days, how can I later review the dates and days of delay in each Task ?
Report Based on Multi Select Dropdown Column
I have a master schedule that includes a multi select dropdown column for disciplines associated with each individual project. I need to create a report that shows all projects with multiple disciples selected. It needs to allow any combination of disciplines as long as there is more than one selected. Unless I'm missing…
How do I sum up the last two characters of a cell?
I have a column where the last two characters are a number. If I do Value(right(cell,2) I get the correct number. I can also add Value(right(cell1,2) +Value(right(cell2,2) But I would like to calculate a cell to be the sum of the right two characters in a column in another sheet. How do I do that?
Summing a column
Hi, I would like to count all the rows in a column where the value matches a specific cell. I can get this to work using countif however I can't get it to work when the column is variable. For example Cell A1 = "Yellow", Cell D1 is the sum of all [A1 value] yellows in the column where the first row =30, cell E1 is the sum…
IF Statement-If text is updated in my "Comments" within the last 5 days I want to return Yellow Sta
Looking for formula help. I have a comments column that I want to make sure is never more than 5 days old. If the comments field is updated with new or different information - I want to return a Yellow star to the Updated field or a date for which it was updated on. Is this possible? Thanks Molly Morton
Can I default cell values to a formula in the form without getting a ' in front?
I have a form entry sheet where I have some columns hidden but defaulting to a formula. The goal is to have the columns populate with the results of the formulas without any updates required (like cutting and pasting the formula in the grid). It works but a ' is inserted so the cell does not calculate and requires someone…
General questions about setting up company projects
I literally just started on this yesterday. we have 7 or so departments and projects within each. Our business is a winery--so departments are Production, Hospitality, Wine Club, PR, Marketing etc. Some assignees cross over to projects in other departments. I want to be able to view these in cards by assignee or…

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Help shape the future of Smartsheet.
Share your ideas and feature requests.

Watch video

Trending in Formulas and Functions

Dividing to Create a %
I would like to use the data in Column A and B to create a percentage complete by row NOT by parent/hierarchy. In Excel this would be =sum(Column B/Column A) = %. What is the formula for Smartsheet?
Looking to Countif a person's name is contained in a column that allows for multiple contacts.
=COUNTIFS({OTP Goals Project Lead}, CONTAINS(Contact@row)) the OTP Goals Project Lead is the sheet that has the column that is a contact list that allows for multiple contacts. If a person's name is contained in that column and it matches the name in the column on the metrics sheet called Contact - then I want it to count…
Replace Multiple Values with Multiple Values
I have a Status column which is a dropdown list. I would like a formula that checks the Status column and returns a different number for each item in the list. Any suggestions on how to do this? STATUS. RETURNED VALUE "NA". "1" "Not Started". "2" "Priors Pending" "3" and so forth.....

Formulas and Functions

Discussion List

Help Article Resources