Hello, I cant seem to get my "at risk" column formula to work. I keep getting #Unpars error message.
Here is the formula I'm using: =IF(AND([END]3<TODAY(),NOT(Status3="Complete")),1,0)
Answers
-
Hi @Tangenna
What are your column names?
You will want to make sure your date column is named "END" and that the status column is named "Status".
I would also suggest using @row instead of the row reference of row 3.
Try this:
=IF(AND(END@row < TODAY(), Status@row <>"Complete"), 1, 0)
If this hasn't helped, can you post a bigger screen capture showing the column names?
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
Hi Genevieve,
Thanks for your help. I entered to formula above and I'm still getting a #UNPARS error. Here is a larger screen shot of my columns.
-
Hi @Tangenna
Thank you for the screen capture! I see that your END column is actually called "End Date"
Try updating your formula to the following:
=IF(AND([End Date]@row < TODAY(), Status@row <>"Complete"), 1, 0)
Let me know if that makes sense!
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.6K Get Help
- 403 Global Discussions
- 215 Industry Talk
- 454 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 56 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives