What might be causing "cell link" to set a cell to blank?
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
-
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 GP| Principal Consultant
Atturra Data & Integration
M: +61493337445
E:Aravind.GP@atturra.com
W: www.atturra.com
-
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
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 379 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 302 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!