dojones
dojones
Reactions
-
Re: Project template sets - weighing options
I think you would be better off using the PMO template if you are wanting rollups of multiple projects into one dashboard. It's what I use to manage around 60 projects. Project Tracking & Rollup …2 · -
Re: Percentage Formula Help
My mistake. Agency Error being a dropdown can't be in the formula. It has to be [Fault of Error] Did you create a County Summary Sheet? In main sheet, Fault of Error should not be a formula, it's the…1 · -
Re: "Record A Date" automation not working
First the sheet must be saved to initiate the automation. You can do it manually or change the setting to 1 min. Other than that, you can initiate the automation immediately by reloading Smartsheet. …1 · -
Re: Formulas to set up KPI's for shipments requests
Use NetWorkDays to exclude weekends =IF([Logistics Completion Date]@row = "", "", IF(NETWORKDAYS([Logistics Completion Date]@row, [WHS Completion Date]@row) < 2, "Pass&quo…1 · -
Re: Suggestions on making this more user friendly?
Some alternatives Col 2: Change checkbox to star. I think this looks better Col 3, Col 4: Use symbol instead of checkbox. Disadvantage is you have to select among several symbols and may result in so…1 ·
