-
Duration formula
I am using one of the PM templates while adding in additional columns for actual start dates and actual finish dates. As such, somewhere I have lost the duration formula in that column. Can someone please help me with the formula that would determine the work days for planned start and planned finish minus weekends? Thank…
-
Multiple Sheets & Formula Updates
I am using Smart Sheets for Paid Search requests. So, when an AE submits a request for their client, we ask them for specific URLs to be entered. In the sheet where they enter in their URLs (via an Update Request), there are some formulas (vlookups) that we use. For the most part, those work fine, but there are times when…
-
New Update - missing the option to open multiple sheets at the same time!
Completely taken aback by the new update. Not only the multiple tabs will be more cumbersome to manage, but I do not see the option to open multiple sheets at the same time and this feature was heavily used in our organization. Smartsheet is this feature gone? If so, could you please bring it back?
-
Document Management Systems
Hello All, We are using SS and considering DMS options (Efilecabinet, Box, M-file) to manage the bulk of docs we handle in the process. Wondering if anyone in the community that has a DMS in place can provide feedback or advice on their implementations. (how well it integrates with SS, potential problems). It doesn't have…
-
Volunteer Allocation
Hi All, I am attempting to find a solution for a specific manual task that is error prone and very time intensive - We need about 300 volunteers occasionally on short notice and need them across multiple cities in 20-50 specific locations (we do not know these specific locations until last minute). I have built a survey…
-
Use data from a form field in the alert email title.
Setting up an alert system that sends out notifications when a form has been completed. To streamline the process I would like to use a field from the form in the email title to differentiate between the emails rather than a range of emails with the same title. Is that possible and if so, how? Cheers
-
Email User Completed Form
I have created a form to capture some series of data. One of the fields on the form is for the user that is completing the form to key in their email address. I would like to create workflow automation when a certain trigger has taken place (example a checkbox checked) for the alert to be triggered and email a confirmation…
-
Resource Management info in a dashboard
Hello, I am creating a dashboard and I need to add a resource view to it, to show the resources assigned to a specific project. Is there any way to do this? Also in the resource view, is it possible to limit the projects considered to calculate the allocation? I have some backup sheets and Smartsheet is taking also the…
-
Card view: Arrange cards by criteria?
Hi there, I have my sheet set to show rows in descending order of dates, from most recent to oldest. However, when I use the card view, it shows the cards in the reverse order -- from oldest to most recent. Is there a way I can sort my cards in the same order as my sheet? Thanks! Jackie
-
IF(ISBLANK with IF work on one Column but not the other
Hello, I was looking all over the Community page and I was able to find the help I needed to make my statement work but when I changed the column in the statement it would stop working. I was hoping someone could explain the difference to me. Below are my examples. 1. Working statement =IF(ISBLANK(task@row), "Not Started",…
