MikeCorvin✭✭✭✭✭

Comments

  • Thanks for the quick response, I shall do that.
    inColumn Header Alterations Comment byMikeCorvin 12/04/19
  • I understand and am aware of this method and have already employed it. However What I am wondering is if there is a way to make strictly private comments without removing the comment column?
    inPrivate Comments Comment byMikeCorvin 11/08/19
  • What do you mean by publish the report? Also what is the point of a report that people can't access!? You can't draw on the report for formulas, people can't view it, you can't reference it for anything...... it seems like a feature with loads of potential and absolutely none of it used. I mean a report is…
    inReport Viewability Comment byMikeCorvin 06/13/19
  • No, The Dashboard Widget is always Viewable; however the Report Sheet itself Is not. Mike
    inReport Viewability Comment byMikeCorvin 06/13/19
  • Thank you! I'll delve further into these :)
    inExternal Inputs Comment byMikeCorvin 06/12/19
  • Andree, I don't have one in specific I am trying, but merely trying to get a feel for what more I can do with SmartSheet at my current locale. One of the biggest things to start with here would probably be PLCs and machine maintenance software. Mike
    inExternal Inputs Comment byMikeCorvin 06/11/19
  • Thanks Paul! Between conditional formatting for main visuals, and grabbing the metrics on the two most important columns it should provide constant and easy oversight for the whole sheet, no matter who goes to take a look at it, from Supplier to Managers. I absolutely appreciate all the help you have given me on this and…
    inBuilding a Dashboard from a Report Comment byMikeCorvin 05/24/19
  • Well if encapsulating all possible user error methods on the main sheet, there may be a cell that is skipped, in some columns it is simply a missing number but if it is the Supplier or Foreign Material column that is blank then that is important. I would like to be able to count as a metric the number of blank cells for…
    inBuilding a Dashboard from a Report Comment byMikeCorvin 05/24/19
  • Okay, I see what you mean and have gotten it in and tested. The only thing that leaves me wondering, is what do you input if you want it to count the cell but it is blank? If i put " " it reads as 0, however if i put "" then it counts everything. That is amazing! While I was decent at Excel (which has transferred over to…
    inBuilding a Dashboard from a Report Comment byMikeCorvin 05/23/19
  • This is amazing Paul! The only thing I can't seem to get is the final metrics piece, =COUNTIFS({Supplier}, 1, {HelperA}, "organic") + COUNTIFS({Supplier}, 1, {HelperB}, "organic") + COUNTIFS({Supplier}, 1, {HelperC}, "organic") I am assuming the {Supplier}, 1, Section is the reference to the other sheet and looking for "1"…
    inBuilding a Dashboard from a Report Comment byMikeCorvin 05/23/19
Avatar