Join the Smartsheet Community
Find answers to Smartsheet questions, learn about project management best practices, discuss the future of work management, and get how-to guidance for every Smartsheet use-case from fellow users and Smartsheet experts.
Discussion List
-
Can i delete dynamic views created by a now deleted licenced userIn Apps, Integrations, and Add OnsI have a licenced user who's profile was deleted but there remains several dynamic views that seem not to have been cleared out that still show in my profile as shared by owner of "deleted profile" - can i remove them? or do i ha…
-
Parent = "complete" when all children areIn Formulas and FunctionsI want a parent cell to register as "complete" when all children have been marked as "complete". I've tried a few things but none are working. Any help would be great!
-
List of reports using a column of a sheetIn Using SmartsheetIs there any way to find out the list of reports using a particular column of a sheet? I want to change the name and column property of a column. However, I would like to know the impact of this change on the multitude of reports that I h…
-
Help with a Currency ConversionIn Using SmartsheetHi there, wondering if anyone can assist.... I am looking for a way to take various native currency amounts in say 2 separate columns (i.e. USD and EUR) - when I enter a respective amount a formula automatically takes that value, changes i…
-
I cannot copy data across sheetsIn Using SmartsheetHello, I am trying to copy rows from one sheet to another. Everyday, because smartsheet cannot upload excel data directly into an existing smartsheet, I upload the data into a new sheet and copy the data across into a sheet which has a da…
-
Single entry from multiple similar rows while sending alert to someoneIn Using SmartsheetHi, Can I have a single entry for multiple similar rows while sending an alert to someone? For example, I have below IDs and Names similar in a file. But when I want to send an alert I want them to group all these into one entry in the ale…
-
Formula for a checkboxIn Formulas and FunctionsOk so what I am trying to do is put a formula in the background of a checkbox. The purpose is the have the formula check a name in a cell, and then compare that value with a list on another sheet. At the moment I have that list typed one n…
-
How to create a top five.In Using SmartsheetHi! I've working on a dataset for a while now that essencially logs the everyday orders we receive from our clients. One of the colums records the name of the customer and I've been trying to create a report that counts how many orders a …
-
How to load Smartsheet data using API via ZapierIn Using SmartsheetI have a REST API which contains data to be shown on Smartsheet. The data needs to be loaded into Smartsheet dynamically. Could you please provide steps to do this using Zapier.
-
Conditional search across multiple columns and get return the rows which has matched datasetIn Formulas and FunctionsHello, I have a sheet with user data (attached screenshot). I would like to design a dashboard or any other way where i can implement conditional search (on columns) and i can get the records (Rows) in return which are matched to those inp…
