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

Count HAS Function Between Dates
I have worked to find a solution out there but not getting one that works. I am collecting data from a sheet to be used in charts on a dashboard (so referencing another sheet). The result will need to be generated from two columns Date - date the project closed Fund - The fund/funds used to pay for the project (multiselect…
Multiple IF Statements Using "ISDATE"
I have an existing formula that enters text based on two criteria: if a date exists in a column, and if that item was closed prior to the anticipated delivery date. The current formula is: =IF(ISDATE([Closed Date]1), IF([Delivery Date]1 > [Closed Date]1, "Complete", "Fail")) I'd like to add an additional criterion that…
Formula
I am trying to identify how many surveys taken at the start of the program are from the Jacksonville market using this formula =COUNTIFS({Time of Survey}, {Time of Survey}, "Week 1 of program", {Data}, "FLJAC Jacksonville") but it retuns as Incorrect # of arguments