Upcoming free webinar on 3/12: Introductions to Formulas!

[Deleted User]

[Deleted User] ✭✭✭

03/09/20 edited 05/31/20 in Formulas and Functions

Join us for an introduction to formulas. In this webinar, you will learn how to:

Reference cells and structure basic formulas
Summarize indented rows with unique Smartsheet formulas
Power metrics with cross-sheet formulas

Additionally, we will be hosting our Advanced Formulas webinar on 3/19!

Learn more and register HERE.

View upcoming webinars HERE.

0 ·

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

Removing commas if a field being joined is blank?
Have a "Reason for DQ" field that aggregates responses from hidden helper columns (finds fields with "bad" conditional formatting). What it looks like unhidden: I'm so close...but so far...how do I keep the commas separating data but remove them if the fields are blank? Forumula being used below: =JOIN([Pre-Bid…
Formula to Join Cells that have Content (with Line Break)
Looking to see if there is a formula that would allow me to join cells into separate lines ONLY for cells that have content. Essentially I want to remove blanks somehow so it is just seamless data. In my example, when I use CHAR(10). It joins the cells, but leaves blank lines if nothing was filled in for a cell. Im…
Course Delivery Date formula
I have a formula that seems simple, but for some reason it's calculating an extra day. There are three columns and the first is duration in days, the next is delivery date, then the third is the end date. What should be happening is the delivery date should be counted as one day, then the calculations should be added to…