Welcome!

Daily metric widget problem in dashboard

Hi,

I have a problem with a metric widget I would like it to show me the row that is for current day. Is there a way of doing it or do I have to make a report.

Find more posts tagged with

Forms

Formulas

Comments

Andrée Starå

Hi,

You'd have to collect the information thru formulas somewhere on the sheet or another sheet. We'd then use the TODAY function to show the current day in the metrics.

Would that work?

Hope that helps!

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

Sign in to join the conversation!

Quick Links

Trending discussions

Automation Change Cell Value not working, but working when Test run
I have a Checkbox (Flag) which should change the Value in a Drop Down List to specific Value, which is with formula then referring to shorter Offset days according to a supporting sheet. When I do a Test run of the Automation it works, but when I manually check the Box, its not changing the Cell Value. INDEX(COLLECT…
Formula to Display Weekday Horizontally
Hi, I have a sheet where i am trying to pull the weekday horizontally based on the dates.But I am unable to fix the formula.Can anyone suggest what formula to use
Need Help With Date Calculation Formula
Hello, I have 2 date columns. I put a test sheet together for a visual reference. The Date 2 column needs a formula to calculate whichever date 39-45 days out is a Friday. Any help would be greatly appreciated.