-
How do I check for duplicates under a parent?
Hello, How could I check for duplicates (children) [Item Number] under a parent [123456]? Note: All parents will be a unique number value, but the Item Numbers will often be the same/repeat across the parents. I need this to check for duplicates under each parent.
-
Creating a Very Basic CRM
Hi, I have the need to create a very basic tool for tracking the interactions between 12 internal employees and 80 external doctors who we work with. This seems like a mini-CRM (Customer Relations Management) tool, but is far more basic as it doesn't worry about sales and such, so many of the sales facing CRM's are way…
-
If there are duplicates for a corresponding Primary Column, I want computation to appear only once
Hi, I am trying to find, how many Promotions are for a particular item for a particular Start Date. Example: Promotion || Total Number of Promotions for Start Date || Start_Date Bacon || 1 || 2/4/2020 Chocolate || 3 || 3/14/2020 Chocolate || 3 || 3/14/2020 Chocolate || 3 || 3/14/2020 Chocolate || 1 || 2/14/2020 Above table…
-
Smartsheet Form Fields (HTML)
While I like that Smartsheet has forms to collect information from users, they are very limited in how data is collected, as well as limited in visual design options. With Google forms, I can create a form, view it in a Web browser, and then identify the actual form fields in the HTML and use those same field codes in my…
-
IF(AND) Statement With List of Expressions
Hello, I'm a fairly new user to Smartsheet and trying to put together some formulas. I'm currently trying to implement a formula to summarize a column called Status if the rest of the cells in that column have a "Complete" entered in them. If there is at least one cell with anything other than "Complete", I want…
-
Forms and Formulas - Form add a row to top but formula does not include
I have a smartsheet that I want to use for team holiday requests.The team would fill in a form that add their request to the top of the smartsheet. Further down the smartsheet is a summary, by team member, of their total holiday allowance, calculated by formula of the number of days requested (and approved) and number of…
-
How to count the number of children based on certain value of parent
The column name is [Task] and a cell value called "Project Details" is located somewhere in the column. Their children is project 1, project2, ... etc.... I want to count the number of children under "Project Details". I know that if the position of the cell "Project Details" is fixed. I can use formula like this:…
-
About the approval request for spesific people
hey everyone, i want to ask about the "approval request automation". i have project that need some approval request for the spesific people. for example, in my organization, i have 2 Divison Manager, which is a different person. so, i create the approval request by the trigger with Division 01, and Division 02. But the…
-
Does Smartsheet have a way of showing hours spent working within the account?
I work at a manufacturing company & have implemented Smartsheet to be used within every department. Right now I am currently the only admin who creates and/or updates the sheets, reports & dashboards etc. We have over 300 active sheets. Needless to say, it has become a full time job all by itself. Unfortunately, I also…
-
How to I indent/outdent tasks in the Task List view?
Hi, I'm new to Smartsheet - I have created a Task list and want to create parent and child rows in a task list, but the indent/outdent buttons are shaded out and the shortcuts (Ctrl ] ) don't do anything. Can you only create hierarchies in a Project?