HI there. I am only a month old Smartsheet user and currently under the Business Plan. i am building the New Hire Request Form for our company and I came across with problem in the multiple approval as well as the things to do before a request will be approved. When the requestor filled up the request form, it will prompt…
I'm trying to create a formula that allows me to count the number of times the word "Postcard", for example, appears in a list in a column. I am referencing a column in another sheet to do so. However, nothing I've tried works. My instinct was to try =COUNTIF({2018 Open Enrollment Feedback Range 1}, "Postcard"). However,…
Not sure if this was a previous discussion item, but wondering if there is a selective way to unhide certain columns, or is just the all option. Problem being I have large amount hidden and at times just want to revert back and unhide one or two. Thanks in advance, Tom
I'm new to the community. I'm sure this question has been asked many times before, but I cannot find a suitable answer: Is there a limit to the number of users that can be active / accessing a sheet at the same time?
Hi, Is it possible for one person to be able to back up and schedule future back ups for the whole of our organisation? I have figured individuals can do this but i would like to put the responsibility into one department and under one person? I would be grateful of any information regarding this. Regards Dave
I have the following formula shown below that changes the Status symbol (Gray/Green/Yellow/Red) based on the Phase/Risk/Change Implementation Date. I tried to update it for a new Phase "Canceled" but I keep getting the error #UNPARSEABLE. Is this due to the fact that I'm trying to have both the Phase "Operationalize" &…
I would like to see the average lease amount per region. I am cross sheet referencing. The formula for the average works. But when I add in the second part (countifs) to make sure a PE GL Checkbox has been checked and to specify a region (I do a cell reference) it doesn't seem to work. For instance, in 1 region I do not…
I'd like to create a formula in a summary cell at the top of my sheet that counts rows in which the value in 1 column matches the value in another column at the same row. I'm hoping to do this without creating a helper column. Example: Col1 Col2 1 1 =1 2 2 =1 3 0 =0 4 3 =0 5 5 =1 I'm guessing there is an obvious answer,…
I'm still looking into this but has anyone had any issues with the sorting feature? We have one sheet that 17 people are constantly working in a day. (All Editors and 2 Admins if that makes any difference) This morning we SORTED several rows and HOURS later someone who had the sheet open, saved their data and INSTANTLY ALL…