Hi all, Our Project Managers are running renovation projects at 300 plus buildings, each project has a single unique row all contained in the Active Projects Sheet The email address for each building manager is kept in a contact column. I'd like to set up an automation that will update them on the construction status for…
I've added a column with a simple formula to check a box when a column clears itself of an error =IF(ISERROR([Written number Ref]7), 0, 1) - woks fine no problem, the box gets checked when it is supposed to Once the box is checked I want to use the move function to move the row to a different sheet, however no luck there -…
你好,为了我们承包公关自动化ocess I am trying to convert numbers to words (preferably dollars and cents) for example $12,345.67 = Twelve Thousand Three Hundred Forty-Five Dollars and Sixty-Seven Cents. Using Google Doc/Smartsheet Merge I have completed most of the project with ease, however i am stuck…
