-
Need a way to identify if a row has been approved/rejected via proofing
Hi, I am using the new feature "Proofing" for my upcoming project and I was wondering is there any way to identify if a document on a row is approved/rejected, then use it in the custom formula to change the status of the row? For example if a document is rejected then I would like to change the status of the row to…
-
How can my rows autofill the formulas when a new entry is generated through a form?
I have worked out several formulas in my sheet. Now I want them to be autofilled whenever a new entry is filled through a form. I don't want to drag them manually everytime there is an entry because I want automated workflow to follow. Also, if I drag a couple of cells prior to the forms being filled, then what happens is…
-
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.
-
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…
-
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:…
-
Placeholders | Still batching Emails
Hi team, I'm using Placeholders in a workflow to generate individual emails for an update request. Although the same individual received the update, they will forward as needed, so I need to ensure each update request for the day doesn't 'batch'. I've done a small test and had no issues, but when i moved into the live…
-
Use Modified Date to show when the last time a sheet was edited.
I would like to enter a formula into Sheet Summary that will show the last time a sheet was edited by a specific person. That person is identified on every row in an "Assigned To" column. I have both the Modified and Modified By columns on my sheet. Somebody started helping me with this, but kinda trailed off. I understand…
-
averageif with multiple criteria
I am trying to find the average of time in position (demographics range 1)when the job class (demographics range 3) is manager or higher. I'm currently using =avg(collect to try to specify the multiple criteria but am getting a #divide by zero error message. I have my formula written as =AVG(COLLECT({Demographics Range 1},…