Best Of
Re: Difference between a number and a target number
It's the way the percentages are looking and I see the issue now. So, for the first column you're asking "How far away from 95% (the target) am I?". The answer is that you're over 95% by 1.5%, so since we're subtracting it says -1.5%. The second column says "How far away am I from 99%?". The answer to that is that you're 2.5% away.
Depending on how you want this to look, there are several ways you could handle this. You could say that anything that meets or exceeds the target goal is "Complete" and then show the variance on anything else. You could leave it and explain to people what it means. There are probably other options depending on how you wanted to do that.
If you wanted to assume anything at or above the target is complete you could use:
=IF(0.95 - [Average Between Both Teams]@row <=0, "Complete", 0.95 - [Average Between Both Teams]@row)
You could also potentially replace "Complete" with 1, which would mark it 100% complete.
Re: Google Mail Distribution Groups in Contact-list Column types?
Hi Dave,
I'm glad you were able to get it to work! I'll mark your response as the "Best Answer" so if anyone else is looking for this solution it will be easy to find.
Cheers,
Genevieve
Community Moderator
Re: Hide #INVALID VALUE or Display Alternative
Try this?
=IFERROR(INDEX(COLLECT({DailyUnits}, {Activity IDs}, [Activity ID]@row, {Date}, TODAY()), 1),"No Data")
You can also use "No Data" to just be "" to display nothing - which is what I typically use.
Re: Counting Unique and First Values Using MIN / COLLECT
You could try something like this...
=IF(COUNTIFS([Lookup Index]$1:[Lookup Index]@row, [Lookup Index]@row) = 1, 1)
Re: Counting Unique and First Values Using MIN / COLLECT
The reason the MIN function still isn't working is because keeping the leading zeros is converting the data into text. The [Row ID] column is still not numerical.
Re: Countifs and formula
Hi Paige,
Glad to hear that you got it working!
Be safe and have a fantastic week!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
✅Please help the Community by marking your post with the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
Re: Help converting a simple IF formula to a column formula
Have you tried changing the [Inherent Risk Level]1 to [Inherent Risk Level]@row? I think that's required for Column formulas.
Re: Why can't I convert =IF(COUNTIF(Email:Email, Email1) > 1, 1) to a Column Formula?
You cannot convert a formula to a column formula if it contains a direct cell reference. In your case it's Email1. You would only be able to do it if it was Email@row
I hope this helps.
Ramzi
Re: Displaying multiple Dashboards
Hi @Doug Stone
I have some 3rd party options that might work.
I’ll get back to you when I find the post where I answered previously.
I hope that helps!
Be safe and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!