What might be causing "cell link" to set a cell to blank?

Z.Win
Z.Win ✭✭✭✭
edited 03/14/24 in Formulas and Functions

I have a health status cell that's calculated based on multiple conditions to become a red/yellow/green ball, but at seemingly random times, cell link changes it to blank.

Then a few minutes later, it says my user changed the status back to green.

This cell is based on a column formula, so the user could not have changed it directly and the activity log shows no other activity at that time, so they could not have changed another cell to have triggered this change.

I guess I'd like to know what other than using the 'Link from a Cell in Other Sheet' might be logged as 'Cell Link' in the history?

Thanks!

Answers

  • AravindGP
    AravindGP ✭✭✭✭✭

    Hi @Z.Win


    It is through your formula. There could likely be a scenario in the formula which is not catered for. Do you mind sharing your formula to help identify what could be causing this?

    Thanks,

    Aravind

    Reach out for any help on licenses, configuration, or training

  • Z.Win
    Z.Win ✭✭✭✭

    Hi Aravind,

    This is where it's going to become convoluted. That formula calculates things based on other calculated fields. Below is the formula, then the other column formulas it is dependent on.

    [RECRUITMENT HEALTH]

    =IF(ISBLANK([SELECTED_CHECK]@row), 

      IF([NET_DAYSOVER]@row >= DaysToRed#, "Red", 

        IF([NET_DAYSOVER]@row >= DaysToYellow#, "Yellow", 

          IF([NET_DAYSOVER]@row >= DaysToGreen#, "Green", ""))))

    [SELECTED_CHECK]

    =IF(AND(ISBLANK([Selection Status]@row), 

        ISBLANK(SOB@row), 

        ISBLANK([Medical Eval Appt]@row), 

        ISBLANK([Medical Eval Clearence]@row)), "", 1)

    [NET_DAYSOVER]

    =IF([Date List Referred]@row > [Date List Referred 2]@row, [Days Over Referred]@row, 

      [Days Over Referred 2]@row)


    [Days Over Referred]

    =IF([Selection Status]@row = "APPLICANT SOB PENDING", "", 

      IF(AND(PosStatus@row <> "Vacant", PosStatus@row <> "Deactivated"), "", 

        IF(ISBLANK(SOB@row), TODAY() - [Date List Referred]@row, "")))

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!