Converting excel formula to smartsheet.

Vixgue0202

Vixgue0202 ✭

08/22/24 in Formulas and Functions

Need assistance if the correct formula for this.=MIN(IF(D23:D28="","",D23:D28))

0 ·

Answers

Jason P ✭✭✭✭✭

08/23/24

Smartsheet look for column names, try =MIN([Column Name]:[Column Name])

Cheers.
0 · Share on Facebook Share on Twitter

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

Formula that will look at how many submissions there have been by group in the last 7 days
I am trying to figure out how to pull the data from a different sheet to build my roll up and dashboard. I am trying to use the following formula. The goal is to be able to show how many submissions there were last week for each group. =COUNTIFS({JHA Tracker with Form Range 66}, @cell <=TODAY()), ({JHA Tracker with Form…
Formula to Evaluate Multi-Selection and Sum Individual Associated Values
I may be asking too much in terms of formula functionality, but here is my goal / question: I have the following columns: Item - These are items that can be selected by the user, multiple items are allowed Price - Price per item User Selection - Received from a form Total Cost - The cost of the selection(s) I am using an…
Index/Match vs Index/Collect vs Index/Contains
Creating a sheet to collect and answer FAQs, I am attempting to populate the System/Tech Supporting SME dependent upon the selected system/technology. I have my primary collection sheet and then I have made a reference sheet for some formulas. Relevant columns with fake data from the primary collection sheet. System/Tech…