Convert excel formula to smartsheet -

AJH3305

How do I recreate this formula in smartsheets?

=+IF(AC2>0,WORKDAY(AC2,10,holidays),WORKDAY(AB2,10,holidays))

Kelly Moore

Hey @AJH3305

=IF([your column name equivalent to AC]@row>0, WORKDAY([your column name equivalent to AC]@row, 10, holiday dates have to be defined in range or individually typed in. It is optional to include this term in WORKDAY function), WORKDAY([your column name equivalent to AB]@row, 10, holiday dates have to be defined in range or individually typed in. It is optional to include this term in WORKDAY function))

Unless you specifically need to reference row 2 the @row is used in smartsheet to reference the current row. It is much more robust in smartsheet than referencing individual rows (unless you must).

https://help.smartsheet.com/function/workday

https://help.smartsheet.com/learning-track/level-1-get-started/formula-basics

https://help.smartsheet.com/articles/2476491-create-efficient-formulas-with-at-cell

cheers

Kelly