-
Release Milestones
I'd like to establish a row that holds our release schedule. Every three weeks I'd like some visual marker that indicates that we've got a new release. That seems possible in Smartsheets, but establishing a cadence of milestones seems to require individual rows for each release. Is there a way to place markers without…
-
Parts of a whole inventory suggestions
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 it there so that it…
-
Smartsheet to SharePoint
Can Smartsheet integrate with Microsoft Flow and be triggered by a Smartsheet row update vs a sheet update. I want to flow updates from my Smartsheet by row/item to a SharePoint list by item.
-
Tips for Showing Count of Answers Completed on a Smartsheet?
If I have a section with three rows underneath my heading, I'm able to easily use a formula to show the count of tasks completed/responded to out of my total number: ="Introduction: " + COUNT(Response4:Response6) + " of " + COUNT(CHILDREN()) However, if I have a section with multiple sub-sections, I'm struggling to use a…
-
Conditional Formatting Not Working for new rule
Hi, 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?
-
Conditional formatting in a single cell based on "IF" formula
I have a simple function I'd like to use. IF cell A2 is greater than cell A1, then format the background of the cell green. If cell A2 is less than cell A1, then format the background of the cell red. Can this be done? Please help and thanks.
-
Conditional Formatting Using Checkbox and % Complete
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 that?
-
Card View - Data Entry (Logic & Formulas do not show up)
I went through a lot of trouble to program my Smartsheet with formulas and logic to make sure the data entry was sound. Only to discover that when someone enters data via the card view, things to not do what they do in grid view. I have many columns to populate and the entire point was to make it easy and smart. Does…
-
Course seat registration
Hi, I'm trying to set up a form for people to use to register for specific seats in specific courses. For instance, on the form, I should be able to select course A with my name and email . At that time, 1 seat from course A on the sheet should be populated with this data, and the number of available seats should reduce by…
-
searching column for value to do checkbox
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 formulas like the below…