The formula is appearing on a particular sheet published report. This reappears after refreshing and saving the sheet. Please help :)
I have a form that's only accessible to registered Smartsheet users. I believe that means that the System: Created By field will always be an email address. In that case, is it possible to use the System: Created By column as a Contact List for things like Notifications and Update Requests? That would be more efficient and…
Hi there, Is there a way to auto-fill across the header? For example, if I put the very first date and then add a formula to add 7 days across until the end of the project? Or do you have to manually enter each header? I am trying to find an easier way to update template headers. Thanks, Jill
I have bunch of demo units that are used by sales people. I want to use Forms to automatically populate a sheet with a customer name, the desired start date of a demo and the planned end date. Subsequently, I want to use Form to release the use of the demo unit (i.e., make it available for others to use it) as well as…
I'm using the project template in smartsheet, in grid view. I've broken my project up in several phases, each phase a parent with child tasks. The Project % complete is coming out as 99% complete, but it is far from being that complete. Is there something I have to do to get this to calculate correctly, or do I have to…
It would be really nice if Unhide ALL wasn't the only option. I print info for several different people and some of the columns need to be seen by some but not all. I hide alot of columns so unhiding all just to change a couple is a total pain and alot of waisted time.
I noticed there's a way to restrict columns for most column types except Text/Numbers. I want to only allow numbers to be typed in and not letters because when letters are typed into those cells, it messes up all my formulas. More specifically, I'd like the editors to only be able to type in a range of numbers, for example…
Hi, I have several standard grid sheets that are populated via webforms, we are based within the UK. The issue I have is that I don't seem able to include "indent" function to the rows (i'd like to indent per month), as the sheets are growing huge as we have a lot of data being submitted from remote and field workers. So…
Hello! Today we have discovered that alerts in one particular (the others are working just fine) sheet are not working. I have tried few tips from the discussions but they don´t seem to be working at all. I have tried to check my spam file in email, even have enabled "Include my changes in sheet notifications"... Nothing.…
A simple method to make a Gantt chart on Smartsheet
I am trying to have a sheet that reports multiple sheets. I have merged cells and that works but I am looking to merge a whole row of dates to a single cell with the most current date featured.
Our whole operation has ground to a halt as the cell limit of 500,000 has been hit. I reduced the number of columns such that the total amount of cells is now well under 500,000. Yet the sheet and form attached still remains inactive. How do I reactivate? Thanks for any assistance from the Smartsheet community. Rgds, Dave
Good Morning, I am having a difficult time trying to find a solution for the following: I have built a Smartsheet and form to collect data from my clients. Many of the fields are pre-populated with data that does not need to change. This would include the client's contact information and other data points. I need to send…
Help shape the future of Smartsheet. Share your ideas and feature requests.