-
Remove "Z" at the end of the date/time stamps in Seat Type Report date columns
The 3 Date/Time columns in the Seat Type Report include a "Z" at the end of the value (ex. 2025-11-11 00:07:27.000 Z). This prevents the field from being used as a date without manually removing it or creating a helper formula to remove it. Please remove the Z from the date/time in Last Paid Activity (UTC), Last Login…
-
Proofing - Comments to persist across all versions
Currently, once a new version of a proofing document is uploaded, it is not possible to see the comments made on a previous version. This makes it extremely difficult to effectively review the new version and ensure all comments have been addressed. Options are now limited to, copy and pasting the comments out of the proof…
-
Quick way to find scheduled send reports from across multiple reports/sheets
Kia ora, Is there a quick way to discover where scheduled send reports, from a report or a sheet, have been set-up, and then modify or delete their occurrence? I have multiple project sheets on the go, and at the close of each I go in and disable all automation workflows, however I don't have capacity (or memory) to check…
-
Is it possible to pull an activity log that includes a cell history report with time stamps?
Hi there. I am relatively new to Smartsheet and have been enjoying all the tools that this platform offers, but I want to see if I can make it work even better for me. I am essentially a process manager that sends reports to various stake holders via Smartsheet status changes The stake holders are dependent on the…
-
How can I pull data from two separate Jira instances projects to single sheet in Smartsheet?
I have two Jira projects which are related to same program but sitting in separate Jira instances. I want to pull tickets related to these Jira project in single sheet so that I can create Gantt Chart view and other reporting at single place for both.
-
Resource Manager Reports - date logic capability expansion
Resource Manager Reports need date logic capabilities beyond the standard last week, last month. Flexible logic like "today()- 2 months", or "today() + 6 months" etc. Having to update an existing report and or the resulting data and formulas each month so it displays the information that is needed rather than just enabling…
-
Merged: Built-In Sheet Health Metrics: Help Us Monitor Limits Before They Break Us
This discussion has been merged.
-
Item Changing with New Information Need Reporting Help
I have test for items a,b,c,d and a report that is pulling data from those tests. Occasionally I'll have an item that will turn to a version 2 now considered a2. Column information wont change. Now there will be an a, b, c, d, and a2 rows. What should I do to pull the correct information to my report now that a (the…
-
Best way to have limited view to sheets withouts needing them to login to smartsheet.
I am not sure which way to go here! I have an intake sheet where different plants can fill out a form with their plant location and other information that all populates to that one sheet. I would like to have the option for when the general managers want to look at how their plants are doing, they can see just their…
-
Way to calculate parent row % Complete in other columns (like % Complete) for SPI.
We have a Planned Value column that is based on Start and End dates and a SPI column that is based on Planned Value and % Complete. Our Planned Value column is used to show what the task % Complete SHOULD be for the project where the % Complete is what the ACTUAL % Complete for the project is. The SPI uses %…