-
Working Days
Hello, I am trying to set conditional formatting to highlight due date cells when it is within 3 working days, however the sheet counts Saturday and Sunday as days. Is there anyway of setting the sheet so saturday & sunday do not count as days?
-
Data -> Exported Form
Hello, I am relatively new to SmartSheets but I am looking to place a form we have now into smartsheets to collect the data there. However our Executive Team likes the look of the original form... Is there a way to export data in a way other then in a grid/ excel looking chart? Id like to customize it and have it run only…
-
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…
