UPDATE 2017-03-23: Smartsheet release yesterday (2017-03-22) may have made this work-around moo. I hope so, but won’t know for sure until I have updated a bunch of sheets. If you find something that still requires this work-around, let me know. Smartsheet has two types of Alerts: Notifications and Reminders. A common request is how toRead more
When I saw the post on the Smartsheet Community, I didn’t think there was an answer. The question (paraphrased) was: How do I reference a cell that does not exist yet? The use case is a sheet is populated via a WebForm and adds new rows to the sheet at the top. A certain columnRead more
One of the FAQ’s in the Smartsheet Community is a asking for a way to have a “Completion Date” cell be updated automatically when a user sets a status to ‘completed’, a percent complete to 100%, checking a “Done” checkbox, or dozens of other ways a task can be marked as finished. For example, a userRead more
Despite (or because of) being active on the Smartsheet Community (when I have time), occasionally I get emails to one of the several emails I have added to my profile there. Here’s one I got recently. Hi Craig, Can you please help me figure out a formula for this situation: I have a ‘Start Date’ columnRead more
The #REF error appears when Smartsheet gets confused. This shows up in the Predecessor column. The most likely cause is a row deletion. When this happens, the dependencies in the project sheet may no longer be accurate. You can find the #REF errors easily using the Search feature I sometimes forget to check – or the #REF showsRead more
Apologies to the Bard. New Stuff Yesterday (May 7, 2016), Smartsheet and Zapier rolled out an update. Go here for Smartsheet’s release notes and while I couldn’t find a page for Zapier’s release notes (looks like they blog them), their documentation has been updated too. In all fairness, I’ve been lukewarm to Zapier. I have a free accountRead more