Hi, I currently have the following formula which is used for counting how many jobs we intend to complete on a day: =COUNTIF({Realistic Completion Date 4}, {Realistic Completion Date 4} = TODAY()) Thi…
Hi All - I would like a formula that reads across vs vertically - here is my vertical one. I need the same thing but read about 10 columns status to then come up with an overall status meaning if ther…
Hello all, I wanted to know is it possible for us to do find and replace in global update and change a Vlookup formula or to introduce a new Vlookup formula. I am trying to do that and i am not succes…
I have contract information entered into my sheet via Web Form. The users are allowed to enter multiple products in at once but asked to keep information pertaining to them in the same sequential orde…
Hi All, I want to create a "Total Vendor Paid Amount" column on our "Main Dashboard". This column will need a formula that pulls information from another dashboard called "REO Vendor Invoicing (3)". I…
I have a form that asks for someone's name. Most of the time, the form is for that person. There are some cases where a person might fill out the form on behalf of someone else. What I'd like to do is…
Hello, We have a project tracking sheet into which people will be adding status updates to a particular cell. Is there a way to easily append the text to the previous text so we can retain history? Pe…
I am trying to develop a dashboard generator so that I don't have to recreate every report I use in our dashboards each time we have a new project. I would like to be able to select the project number…
Hi! I'm really enjoying Smartsheet and glad we decided to go down the path of subscribing. While I was getting certified I found so many neat features and my mind just filled with all the things I cou…
Hello, I'm hoping for some advice on how to create a form with multiple levels. By levels, I mean that some of the information submitted on the form will stay the same and can span many line items on …
