Smartsheet: Secure Your Sheets with X-Sheet References

post image

A Common Request One of the common requests I see on the Smartsheet Community and hear from my customers is how can we make the data more secure? “I want to share only certain data to my _____” (vendor/customer/peer/team member) Repeat after me: Smartsheet is not a relational database. But it is getting closer toRead more

Smartsheet: Cross Sheet References (X-Sheet Ref) are here. Now what?

It has been a long time coming. I wasn’t sure if it would. I wasn’t sure if it should. But it is here, so we better get ready. (Warning: Personally, I’m not fully ready yet. Every time I look at a Sheet or Report, my mind spins with redesign possibilities. Or maybe it’s the meds.Read more

An Alternative to Nested IF’s

post image

An Alternative to Nested IF’s Warning: It takes longer to explain the problem than it does to explain the solution. One of the common issues raised on the Smartsheet Community is problems dealing with NESTED IF’s. NESTED IF are a series of IF statements that are chained (nested) together. These are allowed and occur becauseRead more