Hi all!
I’m looking to create a formula along the lines of:
If Field(Dropbox Link) is Empty and Field(Review Link) is NOT Empty THEN mark the status as “ :x: Incomplete :x: ”
If Field(Dropbox Link) is NOT Empty and Field(Review Link) is NOT Empty THEN mark the status as " :white_check_mark: COMPLETE :white_check_mark: "
If Field(Dropbox Link) is NOT Empty and Field(Review Link) is Empty THEN mark the status as :white_check_mark: COMPLETE :white_check_mark: "
If Field(Dropbox Link) is Empty and Field(Review Link) is Empty THEN mark the status as “ :x: Incomplete:x:”
I’ve tried IF({Dropbox Link} =BLANK(), “ :x: Incomplete:x:” ) which works, but when adding anything onto that, I hit a wall!
Would really appreciate some clarity on this if possible!