-
File Upload from Customer into their Designated Row
I was hoping somebody could help. I have a form set up where customers can upload their artwork directly to our sheet and once checked I send an approval request as a proof. However if the proof is declined or we check the file and it isn't print ready we require customers to upload a new file (artwork). I have tried this…
-
Project Management, If then Statements
Hi, I was wondering about Project Management using Smartsheet. I am trying to create a project where there are many options or collateral pieces that key stakeholders can request from our marketing team based upon the amount of ROI projected and what they rank. E.G. Gold= anticipated $$$ Silver = $$ and Copper = $ If they…
-
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.
