Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template to view 100+ formulas, including a glossary of every function and examples of commonly used and advanced formulas.

Product questions?
Ask it here! The community's got your back.

Formulas and Functions

Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

Creating a Calculator
Hi All - I'm trying to create a calculator in SmartSheets. I'm envisioning it as a pseudo GUI that leverages data from different sheets that we've populated, whereby we input values into this calculator, and it calculates based on predefined equations. There's ways to get close to it through a form or directly in a sheet,…
Amend Timeline bar colour without changing the entire row in GANTT view
Is it possible to amend the timeline bar colour based on a status field in the GANTT without having to update the colour of the entire row in the GANTT view? the only fallback at this stage is to change font colour in the entire row i only see the option to change the entire row, but this is not ideal Also is it possible…
invoicing system
Bit of a long one so please bear with me….. I'm trying to assist a family member with automating their small courier business driver invoices etc So I have built a work book in excel what calculates and creates invoices based on numbers put in on the work book master sheet, but the data inputted comes from screenshots sent…
Extracting text from a multi-select drop down column
I have an intake sheet where one of the fields is a multi-select drop down list. The values in the list are NUMBERS; TEST NAME. I want to be able to parse out just the number into a separate column in the intake sheet as someone submits it, so there'll be a populated column of Test Code Intake that has the NUMBERS; TEST…
How to get rid of the "Reminder" as the 2nd row in my slack alerts
See screenshots of my automations set up and slack alerts. I want to get rid of: row 2 of slack alert: Reminder row 1 of slack alert: Reminder to schedule testing for BD_Proteinase K (Item ID: RGT0172_01, Lot #: 209482) row 2 of slack alert: Reminder row 1 of slack alert: Reagent BD_Oligo Binding Buffer (Item ID: RGT0173,…
How to perform "IF(ISNA(VLOOKUP.." or "IF(ISERROR(MATCH.." when there are multiple items in cell
The sheets I have: Hospital Notification Survey Form - where Regional Directors attest that they have notified one or more hospitals of the upcoming change (for simplicity, I'll say there's 10 total hospitals) Hospital Notification Tracking Sheet - will track submissions from the above survey form's sheet, which ultimately…
Recurring Dates
I am trying to pull data into calendar view where a task or individual repeats every 3 weeks or 21 days. I have the task for a specific date (ie: December 13, 2024) with a formula of (=[ADR Date]@row + 21) that populates the new date into a new column. I repeat this process for the full year using new columns for each…
Column Formula
I wrote a formula but I can't select convert to column and I am not sure why any suggestions? =IF(Shift@row = "Prime", [Hours Calculation]@row / 24, IF(Shift@row = "Single", [Hours Calculation]@row / 8, IF(Shift@row = "Double", [Hours Calculation]@row / 16, IF(Shift@row = "Stand-By", [Hours Calculation]@row / 1.42))))
Challenges and best practices for Total Float with dependency types
This discussion was created from comments split from: TotalFloat Calculation.
We have to 2 Project types and one Budget tracker,
We need to configure if PO Number entered in the Budget Tracker should pick up the Project details of 2 Project Tupes based on the PO number existed in Project types sheets and the PO number existed in Project types has multiple PO number existed in single cell. Can anyone help. Budget Tracker shown below

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Popular Tags

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

Get a Countif on values in a multi-select column of cells
I am trying to write summary formulas to determine how many values appear of each in the drop-down of a column. I tried adding a wildcard, I have tried HAS, and tried CONTAIN, but I'm still not getting the right values. Currently I am getting 0 as a return value on this formula: =COUNTIF([ROI Type]:[ROI Type], HAS([ROI…
summaries in report
Hi i'm trying to build a report with summaries options. i have two column that i want a Min and Max summary. the column for the Min i a texte column and works well. but the other column has formulas and the Max doesn't works. there is a way to fix that? (instead of creating another text column in the source sheets?) here…
Converting email addresses with hyphenated First and/or Last Names
I am trying to convert email addresses into a Name field with the employee's First and Last Name, capitalizing the first character of each part of the name and keeping the hyphen in any part of the name that has one. I started with hyphenated first names so taking shmoe_joe-bob@company.com and converting it into Joe-Bob…

Formulas and Functions

Discussion List

Help Article Resources

Categories

Popular Tags