i have Smartsheet with series of dates representing milestones acheived. Users enter dates as when they have completed each milestone, How do i measure days between these dates and then put into a dash board /charts depicting what the average days between each point is at each milestone. eg Date of request1 - date of…
Is it possible to pull values from a sheet into a form? See screen shot for more information. Thank you
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…