Hello! we use Smartsheet mostly for inventory management and I was wondering if anyone had some suggestions on how to write a formula to automatically subtract the parts that go into each item while also subtracting the completed part. I currently link in the part inventory from one sheet and update
I'm trying to create a condition where if the checkbox is checked next to a sub task, then the % complete of that task goes to 100%, and have all those percents of the subtasks roll up to a parent task showing the overall completion percent of a parent task. How can I do
I've tried to change my conditional formatting rule to grey out "cancelled" status items yet it seems stuck on the old rule. Furthermore, I don't seem to be able to do anything else with it. I've never had issues with these rules before. Screenshot is attached. Any ideas?
I'm trying to set up notifications for milestones that my team hits, looking for a specific ticket # in a column to send a notification when this ticket # is hit (for example, "Hey team, we just closed our 150,000th ticket. Amazing work, everybody!!"). I have tried using a checkbox column with