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
Critical Path Tasks
Hello, I would like to ask how I can create report for critical tasks ? Regards,
Report with only parent rows
I am new to Smartsheet and I'm trying to create a report from multiple sheets that have parent rows and child tasks. I'm looking for a report that puts together all the sheets but only shows the parent rows from each sheet along with the information on that row - percent complete, gantt information etc.
Reports showing wrong criteria
Hi I have been using reports for a while now and everything has been working fine however lately they have been including results that do not meet the criteria I have specified. For example I have a report that's criteria is Column 1 is Yes and Column 2 in not checked that they will appear on the report. However lately the…
Problems with Cell Linking working on some cells but not others
I help develop Smartsheet sheets and reports, and link cells from project plan sheets to an overview portfolio sheet. Recently I've seen where some cells link properly, but some cells don't. I've tried removing the links and re-linking, but to no avail. Guidance is appreciated.
Set Up Conditional Formatting to Enter Current Date
I'm fairly new to setting up my own SmartSheet pages and was wondering if this would even be possible. Is there a way to link a Date column to a check box or a drop down item? For example- I want to have it so that when a certain item is selected from the Dropdown list, a Date column would auto-populate with the current…
Exporting to Excel
I'm unable to export a report with 10,131 rows to Excel. Is there a limit on the number of rows that can be exported?
Two questions on Published sheets
Couple questions: - if a change happens to a sheet that I've published using a link will it refresh with new data or do I have to re-publish every time a change happens? - does the URL change after each publishing? I ask because I don't want to have to be constantly updating the url ie. I can simply provide a shortcut and…
Formula to check if cell contains text string + value in another cell
For example, the value in column 4 row 2 is "xxxxx_email address=test@test.com_xxxxx" The value in column 2 row 2 is "test@test.com" I need a formula that checks if column 4 row 2 contains "email address=test@test.com" by crosschecking the value in column 2 row 2 and using the text string "email address=" I have it worked…
Multiple Entries per One Form
I am creating a form that will be sent to out and will need to be populated with numerous lines of data following the same format. I have read previous posts about Smart Sheets inability to allow one form to populate many row. Is this still the care or has the capability been added? Basically I am trying to create a…
Printing A Sight - printing so small that you cannot read data
Looking for some advice on printing a fairly large Sight. I have had no issues with printing Sights that aren't much larger than what fits on your screen. Push print and that's about it. But - when I tried to print a Sight that was much larger (scrolls down several times in order to see all of the data), it would not scale…
