Smartsheet: Referencing a cell that doesn’t exist yet

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

Smartsheet: Fixed date upon completion

post image

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

Smartsheet: Budget month starts on a particular day

post image

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

Smartsheet: Looking for #REF

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

To Automate or Not to Automate, that is the Question

post image

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