In my operational work I use Sheets as Action Trackers for all the countries we are implementing my project. When I was tracking about 5 countries I got the idea to create workflow that if any task is…
How can I use index match + either another index match or an IF statement to pull Data from multiple sheets? In my case I have 3 sheets: Sheet 1 - Current Project List - consists information that trac…
Hi there Hoping someone can help me with my Automation forms I am trying to send out to my team for a weekly report I need them to fill out. This is what i have set up below and for some reason whatev…
I want to do this… but not sure since Alerts are not a thing anymore - or am i missing it? Smartsheet Inactivity Alert Setup Step-by-Step Process Open your Smartsheet, add modified system column Add a…
As my company's SmartSheet administrator, is there a way for me to see a total number of automations/workflows that exist within my entire SmartSheet account? What about total number of attachments th…
Hi all, I have sheets created with email workflow approvals, there are also email workflow reminders sent when the original request is not actioned. I am getting requested to have an approval option w…
I have an automated workflow set up on multiple sheets to move rows to one sheet when an action is triggered. I've noticed it only works on one sheet. Does that automation only work on one sheet or is…
A workflow enhancement that is similar to the Change Cell Value. However, instead of changing a cell, copy it to another cell. Use case: I have a formula that calculates a date. However, I want to kee…
Hello, I need assistance with managing parent and child rows in Smartsheet. How can I display a milestone as completed once all of its child rows are marked as 100% complete? For example, if I complet…