Is it possible to add a field in the Filter to sort a to z. I would like to sort open items and by what is the nearest due date. Right now it's a 2 step process. Thanks.
I fear that I will be out-of-luck here, but we'll give it a try. We're using SmartSheet to layout a timetable for a tricky real estate development project...fairly straightforward stuff. However our c…
I need help finding the right formula. I have basic Gantt with four phases, each phase has tasks associated with it as well as durations. I've set a "start date" column and by using durations for each…
I am trying to get a sum of % completion based on a Checkbox. For example, if someone checks off 3-4 of the boxes, and I know the weighting for each box (as shown in the IF statement, I would like to …
Hi there I am new to Smartsheet. I've learned how to write basic IF() formulas successfully. Now I am trying to create a formula to turn a flag on if the checkbox column is unchecked. Also, I only wan…
Hello! I'm curious what would be the best way to report a cells previous vs current value. For example, last month we had a status set to 15%, and this month it's updated to 20%. I'd like to see the 5…
I have a spreadsheet for truck maintenance on my vehicle fleet of about 15 vehicles, and I am trying to figure out a formula or some way to send a reminder email if the truck has accumulated 5000 mile…
Hi All. We are trying to make an order form that calculates a number typed by our clients to a box rate. To do this we have tried dividing the order by the amount per box then rounding up to a full bo…
Dear Developer I would like to know if any one be able to help me out (on a chargeable basis) to create a cashflow report that requires the consolidated view from 15 different companies. The idea is t…
