Formulas For Success

Today, we’re focusing on using formulas to make Smartsheet work even harder for us.

Do you ever wish Smartsheet could read between the lines of your data? With a simple combination of formulas, it can.

Let’s say you have a column for comments or task notes. You might want to automatically flag anything that mentions the word “urgent” so your team can respond quickly.

Here’s how:
=IF(HAS([Comments]@row, “urgent”), “High Priority”, “Normal”)

This formula looks inside the Comments column. If it finds the word “urgent”, it automatically labels that row as High Priority with no manual checking required.

It’s useful to:

🔍 Keep your team focused on what matters most.

⚠️ Removes the risk of overlooking important updates.

🤝 Works perfectly alongside conditional formatting (e.g., colour-code “High Priority” rows in red).

This small but mighty formula is a great example of how Smartsheet can help automate your everyday tasks and reduce human error which saves time and keeps your workflow smooth.

If you’d like to explore other ways to make your sheets smarter, our team can help build custom automations that work just like this, but across entire processes.

To find out more about formulas, contact debbie.sawyer@smarterbusinessprocesses.com to discuss creating a bespoke workshop.