Calculating Azimuth Based on Departure and Latitude!

Options

Hi all! I am trying to translate a formula I have been using in Excel to work in the Smartsheet environment. The use of this formula is to calculate the azimuth from one point to another by using the latitude between the points and the departure between the two points. This is the formula that works in Excel:

=IF(AND(C10=0,B10>0),"EAST",IF(AND(C10=0,B10<0),"West",IF(AND(C10>0,B10=0),"North",IF(AND(C10<0,B10=0),"South",IF(C10="","",IF(AND(C10>0,B10>0),DEGREES(ATAN(B10/C10)),IF(AND(C10<0,B10>0),90+ABS(DEGREES(ATAN(C10/B10))),IF(AND(C10<0,B10<0),180+DEGREES(ATAN(B10/C10)),IF(AND(C10>0,B10<0),270+ABS(DEGREES(ATAN(C10/B10))),"")))))))))

For my purposes, C10 = [Latitude]1 and B10 = [Departure]1 in Smartsheet world. I think my main issue is Smartsheet doesn't use ATAN and the formatting is a bit different overall. Any suggestions would be very helpful! Thanks in advance!

Answers

  • Brian_Richardson
    Brian_Richardson Overachievers Alumni
    edited 07/08/24
    Options

    I'm afraid this is going to be impossible in core Smartsheet. Smartsheet doesn't have any trig functions or degrees.

    If you have Data Shuttle, you could export your sheet to an Excel stored in Drive, Box, Sharepoint etc and that has columns setup with your trig functions. Then reimport the data back to the same sheet with the data from the formulas.

    Alternatively you could use Bridge and Javascript to run these functions

    BRIAN RICHARDSON | PMO TOOLS AND RESOURCES | HE|HIM

    SEATTLE WA, USA

    IRON MOUNTAIN

  • BGoldAK
    Options

    Hi Brian,

    I see! I will look into one of those workflows. Thank you for the quick response!!

  • Carson Penticuff
    Carson Penticuff ✭✭✭✭✭✭
    Options

    How accurate do you have to be with this? ARCTAN can be estimated pretty close using series expansion (see "Taylor Expansion"). This could be setup as a form of longhand in Smartsheet. It's been a couple decades since I last messed with trig, but I believe it would be doable.

  • BGoldAK
    Options

    Pretty accurate as we're using it to convert GCP/field points to a known base point. I will look into that though, it may be within our tolerances. Thank you!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!