So, you want to show “Yes” based on the value in a column, if the value not meet the if condition, then show the value? Here is an example: show “Yes” if the original value is blank. Let’s say you have a column called [ Original Value ] And You can a...

If the column type is duration, then the output of formula needs to be duration, if you want to output Total Hours, which is a number, the column type should be decimal or number.

“/” character is not allowed in app name, remove it and the app name will pass check.

First question: So you have columns let’s say A B D E F… And you want to add a new column C, and want to make the table like: A B C D E F ? One way is to modify the spreadsheet, right click column B and then “insert 1 right”, name the column, for exa...