How to set a cell value based on another column. If false do nothing to original value
I have a status column that is a dropdown list. I also have another date column "Goods and Services Received" that pulls a date using a VLOOKUP from another smartsheet. What I am trying to do is change the status column to "Complete" if there is a date in the "Goods and Services Received" column of the reference sheet, but leave the original value in the status column if there is no date in the "Goods and Services Column".
Help Article Resources
Check out the Formula Handbook template!