Hello, I have a bit of an odd situation and I'm hoping that someone might know how to help. We have a Smartsheet that we use when new clients come on board so that our Customer Care team can complete the account setup.
The new clients are added to the Smartsheet via a form and we have formulas to automatically add "N/A" to certain columns depending on the value of other cells. These columns are set up as check boxes and will appear either with the checkbox so that the staff can check when the task is complete or "N/A" if our staff don't have to perform this task.
It all works great until our customer care reps become too efficient and check off the box in the top row before another addition is made to the sheet. The formula is then erased for all future rows.
Is there a way around this? Is it possible to put the formula in a hidden column and have the results appear in the checkbox column? Any advise is appreciated!