Can I make my status column read both the line above it and the column next to it using a formula?
I've been doing some research on IF, AND, OR equations to try and automate my sheet. Is there a formula that I can plug into the cell highlighted in the image above that reads not only the Status of the line item above it, but the Complete column at the row level as well?
I would like for an artist to come in, check off their task as complete, the Status of that row then becomes "Complete" and then the next row task below to change to "In Process". I have a feeling my equations are SUPER close but I am missing something... like the ability to tell the equation what is most important
Complete check mark box trumps the Complete status in an above cell.
Equations I have tried:
=IF(OR(Status175 = "Complete", Complete@row = "true"), "In Progress", "Complete")
=IF(Status175 = "Complete", "In Progress"), IF(Complete@row = "true", "Complete")
Thank you!
Best Answer

Try the below:
=IF(Complete@row = 1, "Complete", IF(Complete175 = 1, "In Progress", ""))
Answers

Try the below:
=IF(Complete@row = 1, "Complete", IF(Complete175 = 1, "In Progress", ""))

Leibel you are amazing. Thank you so very much! This worked.
I never thought to tell the equation to look at JUST the Complete column. Genius! I knew I was missing something.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 61.2K Get Help
 320 Global Discussions
 197 Industry Talk
 415 Announcements
 4.2K Ideas & Feature Requests
 126 Brandfolder
 153 Just for fun
 123 Community Job Board
 441 Show & Tell
 26 Member Spotlight
 1 SmartStories
 276 Events
 34 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!