-
FIX Required: Last Modified Date + TODAY Function = updates all rows
Hello Smartsheet community I would like to see a fix. When you use the "TODAY" function anywhere in your sheet, ANY changes will update the "last modified date" for all rows. What I want: Only update the individual row that has changed. Why? So I know when (and who) made the last change. This was verified as a problem by…
-
Why is my sheet not showing up as a data source for a metric widget
Hello, I have two sheets in a workplace as show below. However, when I go to add a metrics widget to the dashboard only one sheet shows up as a potential data source. How do I get the other sheet to show up as a data source. As of now the metrics sheet is a column of descriptions, then a column of the calculations. The…
-
Dynamic View Logic should behave like Conditional Form Logic (aka "live")
Logic in Dynamic Views should work as it does in Forms - changes / info entered while filling out the form results in changes to the form based on established logic. Instead, DV Logic is applied only when a request is loaded or saved. This is a follow-up to an old discussion on Dynamic View logic behavior (here) PAIN…
-
Creating a Calculator
Hi All - I'm trying to create a calculator in SmartSheets. I'm envisioning it as a pseudo GUI that leverages data from different sheets that we've populated, whereby we input values into this calculator, and it calculates based on predefined equations. There's ways to get close to it through a form or directly in a sheet,…
-
Download attachments from multiple rows
I'm trying to download attachments from multiple rows all at once rather than selecting a row and then selecting download since there are MANY. The only option I see is done in true Smartsheet fashion. I select All in the attachment summary and then I can scroll through the thousands of files that are in a completely…
-
How Generate Quotes Via Smartsheet
I am looking at making our internal quote system entirely through smartsheet. Is there a way in which i can expand a row in order to make relatively complex quoting system which almost acts as a mini excel sheet per row. the output would be a price but if needed the breakdown is seen. I would like the the Quote numbering…
-
Text to different Rows - Split by delimiter.
Hi, I have a cell@row value in the column Zone1 separated by a delimiter which needs to be split into different rows as a list of values similar to column Zone1new. Could i get help on this?
-
Move Form to Different Folder
When creating a duplicate of a sheet/form, it would be beneficial to move it to another folder. Say you have a 2024 sheet/form and want to update it for 2025- you would duplicate the 2024 version, update it, and save it in the 2025 folder. Currently that is not an option.
-
SDLC Portal
Hello team - Has anyone built a SDLC workspace for complete tracking of a project or activity? I am trying to build the following and looking to see if any of you have found a good solution?
-
Daily Update Solution without the need to open the sheet, use Zapier, or similar
Hi everyone, Happy New Year! I hope you're well and safe! I've developed a way to use the newly released Record a date feature to update sheets with today's date automatically without the need to open it or similar. 1. Add a so-called helper column. (Date). We can call it Today Helper and add a date before the current day.…