I want to alter this sheet, found in the IT ticket Template, to just show the metrics for a specific customer. the original formula looks like this: =COUNTIF({Created Date Range}, IFERROR(YEAR(@cell), 0) = YEAR(TODAY()) - 1) and my attempt to specify to a single customer looks like this =COUNTIFS({Created Date Range},…
Hello SS Community! Does anyone of examples of a Corporate Emergency Preparedness Checklist that one can share with me as a starting point? Tips greatly appreciated!! Thank you!
Can an email template be built in Smartsheet that can accept free form text in certain fields and also be able to be emailed out in the G-Suite to a DL. The other condition would be to be able to reuse the sent email message and be able to send subsequent email updates using the same email thread in the G-suite. Not sure…
If my dashboard template has links to a dynamic view for a sheet template, will those dynamic view links update when new projects are provisioned through control center? Or will the dynamic view always link back to the template?
Hello, I have a Blueprint set up in Control Center that is used to provision new projects. I want to add a sheet to my template set to compare projected direct labor from the schedule we have set up with the actual direct labor we have feeding in through Data Shuttle. The schedule is set up with phases as the top level and…
hello, when a new templete is submitted, my formula won’t apply to the new row. Other columns will apply the formula, however “End Time Parse Left” won’t. How can this be resolved? please see photo below:
Hello, I am new to smartsheets and use it for work here, in the healthcare field. I am trying to figure out the best way to utilize smartsheets to track productivity for a multisite clinical trial. I have found some articles describing how you can use other products along with smartsheets to track just single site clinical…
We are using the Project Schedule Baseline functionality, but recently learned that the Schedule can be Reset or Removed. Is there anyway to track how many times a Schedule has been 'Reset' or 'Removed' and baselined again? Our concern is that without the history being tracked on how many times it's been reset, we won't…
Hi, I am currently on this page and have downloaded the Packing Slip Template. I have opened it in smartsheet, but cannot find out how to make it look like the Final Draft that this page shows. Am I missing some feature?
