Conditional Formatting and IF Formulas
Hi all,
I'm working on an automated KPI Tracker, which works well.
However, I'm after some advice on how I can make the sheet work better for the team.
I'm using a series of IF Formulas in Helper Columns to determine if the monthly values are reaching the years target. However, Smartsheet is colour coding future months with no values as 'Yes' or 'No'.
=IFERROR(IF(November@row = [This Years Target]@row, "Yes", "No"), "Not Present")
Ideally, if the month's data hasn't been submitted the November (and the future months) cells should just be white with no conditional formatting applied.
I think my issue is in my IF formulas, they are too basic.
However, I want to try and keep this sheet as generic, so it can be used for following years, its just the Year Target that changes for next year if that makes sense.
Thanks in advance,
Jack
Answers
-
Hi @Jack Parry
I hope you're well and safe!
Try something like this.
=IF(November@row = "", "Not Present", IF(November@row = [This Years Target]@row, "Yes", "No"))
Did that work/help?
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 support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
@Andrée Starå Worked perfectly! Thank you :)
-
Excellent!
Happy to help!
✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 430 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives