Formula working in some cells in Smartsheet but not others.

edited 02/02/24 in Formulas and Functions

I am using this formula to determine if a particular training asset is on schedule or behind schedule by comparing the draft start and end dates. If the time between is greater than 5 days then Smartsheet returns red and if the time between is less than 5 days, Smartsheet returns green.

=IF(NETWORKDAY([First Draft Actual Start Date]@row, [Draft Actual End Date]@row) > "5", "Red", "Green")

The formula works for most cells but some cells return the incorrect color (for example if the training asset start and end date is past 5 days, green appears instead of red). Why is this happening? Has anyone experienced something similar?

Best Answer

  • KPH
    KPH ✭✭✭✭✭✭
    Answer ✓

    Can you remove the quotation marks around 5:

    =IF(NETWORKDAY([First Draft Actual Start Date]@row, [Draft Actual End Date]@row) > 5, "Red", "Green")


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!