Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums.
Discussion List
Enhancement Request: Allow Wrap to be turned on in Reports
I often come across columns in a Report that I would like see with Wrap turned on. These are sometimes (usually) columns/cells that I do NOT want to turn Wrap on for the source Sheets. Reports inherit their formatting from the underlying Sheets* and I realize this may be a difficult change to implement. However, I also…
adding service records to a row
I have a plant & vehicle register that I want to add service records to. So each row is a vehicle and I want to keep each service record as a history of the vehicle then I need to export the record for my clients is there a way to do this without adding extra columns?
Locking Formula ???
Hi Team, I find my formulas change when i filter etc. e.g. =SUM([Value Of Jobs]2:[Value Of Jobs]85) =SUM([Value Of Jobs]18:[Value Of Jobs]85) My top row which i use to calculate columns keeps changing. How to I fix or lock formulas please.
Using Webform to update/edit information of a row
Is it possible to use a look up function in a Webform to find a specific row of information, then populate fields related to that row, and make changes in the Webform to modify the related information to the row in SS?
Counting overdue dates
Hi, I'm trying to include a formula that counts overdue dates (by inputting 1 in another column and then using SUM). It works but if the date is left blank it still includes '1'. The reason I have some black is it's the only way I've found to 'check it off' as sent. Any suggestions greatly appreciated.
Milestones Report on a Sight
I've got a Report that I'm pulling into a Sight. While in the report, I properly see the diamond symbol for my milestones, yet, once I pull the Report into the Sight, it's showing me the bar, not the diamond. See the screenshots - the one showing the diamonds is when I generate the report. The one with the blue bar is the…
Enhancement Request: Add "unfilter" selection when searching filtered sheets
When searching in a filtered sheet and the results are in the filtered rows, please give option to unfilter from the dialog. This request has also be posted to the Form Craig
Enhancement Request: Add "unfilter" selection when searching filtered sheets
When building a Report, I get the message "You need to specify at least one criteria to run the report" when the data set is blank but I have added a criteria. This inaccurate message may confuse new users. This request has also be posted to the Form Craig
Excel lookup formula in smartsheet
I have a risk register created in excel that has a tab named "lists". There are lookup formulas in the risk register that references data in the "lists" tab. Since smartsheet won't let me make tabs to my Register, how can I make the copied formula work. Here is an example of the formula:…
Conditional Formatting to work on rows like they do on columns
Hi Is it possible to set conditional formatting on rows like it is for columns, or is there a workaround? Thanks Cheers Richard