Harvey Ball Automation
Hello, I'm fairly new to smart sheets.. however I am trying to get the Harvey status ball to auto update.
I can get one string to work properly but when I try to add another "IF" function it throws an error.
When a date is entered in the desired columns I want it to auto spin the wheel.
I know i'm missing some logic here, thank you for your help!
Comments
-
Hi @KC Fife
Could you perhaps provide details for when you want each version of the ball to show?
Logic formulas read left-to-right and stop as soon as something matches the criteria. This means that if we fixed the current formula you have, it would only move to the second statement & look at the Turnover Meeting Complete column if the first column (LOI) is not a date. If that first column has a date, it will stay at "Quarter" and never look to the other statement.
It looks like you're just missing a closing parenthesis after the pink text (after @row, before the comma). This closes off the ISDATE function so it knows what column to look at.
You could try swapping the statements around:
=IF(ISDATE([Turnover Meeting Complete (PE)]@row), "Half", IF(ISDATE([LOI (PE)]), "Quarter"))
This way, your statement will only check the first column if the last one is not a date... working backwards. Does that make sense?
Thanks!
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 437 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!