Is there any best practices for continuous testing of smartsheets?

Ideally I would like to create a test row, utilize the smartsheet API, or some other approach that executes on a periodic basis to ensure a Smartsheet continues to function as expected.

This would be the smartsheet equivalent of a Unit Test for a piece of software that could fit nicely into a CI/CD pipeline. Reason being is I just started a new position at a company which is rapidly deploying Smartsheets that could or already are supporting core processes. My fear is these could eventually be swept up into an audit and lead to negative feedback.

Answers

  • Mary_A
    Mary_A ✭✭✭✭✭✭

    This would depend on the Smartsheet Element you want your test to exercise. Are you checking that automations kick off? That a function resolves? Interactions between sheets?