MCorbin
MCorbin
-
Re: Dashboard Chart to Match Current User Report
You need to create a metrics sheet. Have your users in the rows and each column is your status (Reviewing Request, etc) The formula in each cell would refer back to your raw data sheet: =COUNTIFS({Re…6 · -
Re: formula
First - I recommend that you create some helper fields for your dates. It makes your formulas a lot easier. In my screenshot, these are the left 2 columns. You can hide them after you set up your for…1 · -
Re: Pivot Tables on Dashboards
OH! And a 3rd way.... Use a Chart Widget to display the data from your pivot in a graphical format.1 · -
Re: Can you create a drop down list from values in a column?
Not automatically when a record is saved.... If you have Data Uploader, one of the options in DU is to update Dropdowns. You could do something fancy where you export data (via scheduled report) from…1 · -
Re: SUMIFS not Working
The formula should work, but without being able to see what your Ranges are referencing, it's a little difficult to troubleshoot. Here are some things I would check: 1) Make sure the Job No in both s…1 ·
