-
Counting Distinct items.
=IF(COUNTIF({Client Name (Pruning)}, [Client Name]@row) = 0, "", COUNT(COLLECT({Annabelle Name}, {Client Name (Pruning)}, @cell = [Client Name]@row))) The above formula works great after receiving help from a member of this community :) The formula is counting the rows with the criteria; however, there are duplicates…
-
Best Practices of archiving sheets
Hello, I currently use a form to populate a sheet for any new sales leads. We're at the end of our fiscal year and I'm trying to archive all old leads and start a new sheet. I want to know about some best practices of achieving this. I was thinking about the following ways: Move all open leads via automation to a new sheet…
-
Modified "Report" for client
I have a contract with 262 units that are being reported into 10 database sheets. The finished product I am looking to have is a sheet with the 262 units displayed vertically with the Projects horizontally, with the quantity reported on each project in the row of the corresponding unit. I was successfully creating cross…
-
PROPER Function
Hi! I wanted to submit a feature request to add to Smartsheet. I organize a lot of documents that are displayed in all caps [Ex. PLEASE SUBMIT ADDITIONAL NEEDED DOCUMENTS]. I have noticed there is not an action/formula available that changes the text to PROPER like in excel [Ex. Please Submit Additional Needed Documents].…
-
Open files in a new window
A recent update in Smartsheet changed the way we view files. Previously, when you clicked on a file it opened automatically in a new tab and this meant you could have several files open at once and the ability to move between them. The update removed this function and now the file opens in a preview window with little…
-
Update Template
I would like to see an option to edit/update a template without using the template to create a sheet, editing the sheet, and saving as a new template. The current process creates additional templates that might have to be renamed and then removed. If we could edit the template itself, it would make the process much easier…
-
Merged: Rand() function
This discussion has been merged.
-
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,…
-
Folder Order
Hi - I am new to Smartsheet and trying to figure out how to move my folders and place them in the order of the workflow I want.
-
Is there a quick way to identify or List all the Smartsheet Links?
Hi There I have a worksheet that I have inherited, and need a way to identify all Links from a cell in other sheets. Is there a report of function on Smartsheet for this? Thanking you in advance for your assistance. Warmest Regards Dickson