I am trying to find the first duplicate value with the purpose of using that to highlight another cell; however, my attempts at the first part of the process have resulted in both #UNPARSEABLE and #INVALID COLUMN VALUE. The formula I'm trying to use mimics something I've used successfully in Excel: =COUNTIF($[Master…
It would be extremely useful to be able to summarize columns by weighted average in a report. Currently only a general average is available which can skew metrics that deal with percentages. Maybe even provide the capability to input custom formulas for certain cells or columns?
Today in order to share data in Reports we would need to provide view/edit access to the underneath sheet / source sheet. That's not exactly what many of users expect from Reports. This is a pretty typical task to have a data frame (source sheet) and using Reports provide access to certain portions of data to different…
We currently use Teamwork for project management. Our account managers update their milestone dates in Teamwork to create their job schedules at the beginning of a project and then adjust the dates as it progresses. Our organization-wide job board is kept in Smartsheet and we run several reports from it (including monthly…
Request: When cells have long wrapped text that have more than 3 (or 5...) lines, truncate the rest and provide a "show more..." link to expand the rest of the text. This will greatly compress sheets and rows that contain longer text. Example: goes to Comments: I am aware that I do not need to wrap text, and that will…
Hi Friends, I am trying to create some analysis tools at work, assume the following scenario: I have a smartsheet filled by an online form employees fill out. Each form filled and sent creates a new row in my sheet. columns like Name Location Date of entry dropdown value a dropdown value b How can I count entries and have…
Hi Friends, I am new to smartsheet, please be aware of that, likely some of my struggles are obsolete but I just have no idea. Problem Statement: On global business level, we created a form for employees to forward improvement Ideas to a specific team that will execute them (or not). The form entries are logged in a…
I have a large planner with several colleagues making edits (helps spread the workload). I created a report so that I could see for the current week, what rows were edited and by whom. I applied a filter to narrow down the date range of modification but the result is a page full of nearly the whole planner! The filter…
Be able to choose whether wrap text is applied to sheet names when included in a report.
I'm a training program manager and am trying to equip our learners to be able to see what trainings they've already completed so they don't re-register for trainings they've already done. My "vision" for this is a report that pulls attendance data from all registration sheets that I can share with the entire learning…
