Sheet formula efficiencies

Derek Hermsen
Derek Hermsen ✭✭✭
edited 12/09/19 in Formulas and Functions


I have a feeling that I should be using "@cell" or "@row" in a formula to make less calculations.  Can anyone shed light on a better formula than the one I have started? Basically trying to determine if a date falls between two other dates through a range (i.e. find out which year/quarter that a specific dates falls within). Screenshot:

smartsheet atcell.JPG


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!