-
Will adding Data unto Webforms be added automatically to the spreadsheet?
How do I get the data I entered on a webform to get added unto the spreadsheet I am working from? Can I do both or does it have to be either 1. use the Webform or 2. enter data unto the spreadsheet?
-
Sum of column items respecting the filter
Hi all, I've started using Smartsheet recently, so I am sorry if this is a newbie question ;) I've tried to search for a solution, but nothing specific about this came up. Anyway, I got the column SUM as open-ended, summing all rows correctly. But when I enable a filter, for example only seeing rows in last 60 days, the…
-
Complete a Partial Update Request
Our marketing department sends update requests to our project managers so that we know which projects are expected to be marketable projects. If they are marketable then it triggers other actions. Often, I have 10+ projects that I need a single project manager to update me on. Is there a way to send an update request that…
-
Determine Hours from Duration
Has anyone created a sheet or formulas to calculate the montly hours from duration? This is easy if the entire duration falls in one month but I'm struggling with calculating the monthly hours for extended durations. For example, how many hours are allocated in each month if I have a task that starts January 11, 2016 ends…
-
How do I use an OR function with a simple IF function?
I’m currently using this simple IF function (If Team Column equals “Undergraduate Robing”, check the box (formula below) but I need the box checked if the team column equals “Undergraduate Robing" or “Faculty Robing” or “Marshals”. Is this possible? Current Formula: =IF(Team1 = "Undergraduate Robing", 1, 0) Any assistance…
-
How do you change (or can you change) the owner of a sheet?
I am managing the implementation of Smarsheet for our organization. I recently created a sheet to 'test' various capabilities and to determine if it might work for sharing specific information needed throughout our organization. It does; however, now another person (rather than myself) will be managing the information of…
-
encrypted using an obsolete cipher suite
When I look at the certificate use for my Smartsheet connection I see "encrypted using an obsolete cipher suite" What does this mean? It is all safe?
-
Copying Rows With Attachments to Another Row in Same Sheet
Hello, I'm not aware of a current way to do this, so I'm hoping for quick solution. In our use, we find ourselves needing to copy and paste rows with attachments into a new category in the same sheet from one row to a new row and currently the only way I see to do it is to download the attachments and then upload to the…
-
Creating a Summary View Sheet
I have a sheet which has information on Projects and Activities my team are working on across the whole of my region. If has columns such as Activity Title, Person, Region, Partner, Status This shee it great but I would like to create a linked sheet which gives me total counts for each for each Person I would like to know…
-
Linking OneNote
Hi, Is it possible to link notes taken in OneNote to a project sheet?